I have been having a lot of trouble trying to consolidate a worksheet found in different files into one main excel worksheet.
I have the same excel worksheet found in numerous workbooks in the same folder. The data format and headers are the same in each worksheet as well. Hence, I am trying to pull out all the data from the different files into the same worksheet. However, the files all have different names. I have their partial name, for example it will start with ABG followed by a string of numbers. A sample file name would be ABG-xxx and ABG-yyy.
Does anyone know of a way I can consolidate all of these data from partial file names into one consolidated worksheet?
Any help would be greatly appreciated. Thank you!!