I'm interested in using a macro that can go into a folder and find all files in the folder with a given word or phrase included in the file name (e.g. "May"). For each file that has this word in its name, the macro should pull data from the tab labeled "Data". The data from each file should be copied to the 1st tab of the excel file with the macro (the "Collector" file). The top row of the "Collector" file will have the headings, so the data from the 1st file in the folder should be brought in starting in row 2 of the "Collector" file. The 2nd file (if there is one), should be placed in this same tab of the "Collector" file under the data from the 1st file from the folder. This process should be repeated until all data from the files with the specified word/phrase have been brought into the 1st tab of the "Collector" file.
The data from the excel files in the folder may change, so the old data in the "Collector" file should be cleared before updating with new data each time the macro is run.
Any thoughts?
Bookmarks