Thank you again! It works perfect! I really appriciate it

I have one last question. I want to extend the formula a bit more. I want to use a filter function, after the sheets has been imported.

The process:

1) The VBA code imports all the company sheets to the "macro" file in the folder automatically.
2) The VBA code filters in the Macro file where all the sheets have been imported.

I have attached almost the same files and I have included one file that show how I want it to look after running the VBA code.

CompanyA.xlsxCompanyB.xlsxMacro - How I want it look after I run the macro.xlsmMacro.xlsm

Again, thanks!!