The code must be in My Macros Copies the specified Sheet from multiple Documents in a specific folder to a new Document.' The code must be in My Macros ' Copies the specified Sheet from multiple Documents in a specific folder to a new Docu…