I have dozens of excel files (each having different number of sheets). However each excel file has a sheet named "ALL"
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 in the sheet "ALL" 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.