Consolidate Import Data From Same Sheet In Multiple Workbooks In To Single Workbook

[Jorrg1]

Hi

I want to be able to create a macro that can import sheet(s) from a excel file in a folder.

Detailed explanation:

Attached files:
- Macro
- ComapanyA
- Company

1) I want the VBA code to be made in the "Macro" file.
2)I want to import the tabs "import this" from the CompanyA and CompanyB files. These are tab number 3 in each company file. It would be best to link it to the name "import this", or link it to tab number three.
3) I want the sheets to be imported to the CompanyA and CompanyB tabs in the "Macro" file.

CompanyA.xlsxCompanyB.xlsxMacro.xlsm

Thank you very much

Kind Regards

Jørgen

[Excel Fox]

Posted here Macro To Import Data From Multiple Workbook Sheets In A Folder