I have been looking for a solution to a project I am working on. I want to copy all data contained on the second worksheet in each workbook located in the same directory into one master workbook. Each external workbook's data would be pasted into its own sheet inside the master workbook. I am then planning on having a master sheet inside the master workbook that will reference this data and manipulate into a common template I utilize.

A problem I have been running into trying out other solutions in this forum is that the external worksheets I am cycling through have their own macros inside them. So I am assuming I will need a solution that either turns off macros when opening the external worksheets or does not open the external worksheets at all.

Thoughts?