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

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.

Attachment 727Attachment 728Attachment 729

Thank you very much

Kind Regards

Jørgen

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