Consolidating different files into one main excel worksheet

  • Hi,

    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!!

  • Try this, remember to enter the correct file path