Help adjusting macro from merging worksheets to pulling data from workbooks and merging.

Here is the code. The worksheets will be in separate workbooks all stored in the same folder. I want to copy the data into one "Master" workbook. The workbook will have other sheets that another macro will mess with. I have about 8 workbooks to pull data from.

Please Login or Register  to view this content.

Possibly...

Please Login or Register  to view this content.