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.