Help with Macro to Merge Multiple files with Multiple Tabs

  • Hi,

    I need help with a macro to combine Multiple excel files and have the data in the tab

    Each excel file has 3 tabs max with fixed names, but the content in the tabs can be anything.

    So i need the macro to:

    A) Merger all the excel files into 1 master file with 3 tabs

    B) have the name of the file in the first column of the sheet of each row, so if i filter by the first column i can see all the data from that file.

  • Hello Funfex,

    See if this at least heads you in the right direction:-

    You'll need to place your file path in the variable stgP.

    I hope that this helps.