I have 10 to 300 reports in any given month in a folder at C:\Users\FakeUserName\Repository.
Each report has a page called "ImportData".
On ImportData Sheet, there is 1-5 rows of data.
Is there a script that will open each workbook individually in the aforementioned folder, copy the data on ImportSheet into a new workbook titled "Master Import File" on the Desktop, and then close the original workbook? Rinse and repeat for each workbook in the folder?