I have dozens of excel files (each having number of sheets). There is exactly the same data in all files and sheets with the same headers
1. All the files are named differently
2. All the workbooks have the same number (4) of sheets with same names ("001", "004", "058", "002").
I would like to write a vba code that all data from different files will be consolidated into single new excel file without actually opening the files???
I need this as I have dozens of files and it will take a long time to manually copy paste data manually.
I will be very thankful for your help.
See attached the sample of one of those files.