Hi everybody and greetings from Norway

I want to be able to create a macro that can import data from same sheet in multiple workbooks into a single Workbook. All the files are in the same folder.

Attached files:
- Macro
- ComapanyA
- Company B

CompanyA.xlsxCompanyB.xlsxMacro.xlsm

Detailed explanation:

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

Thank you very much

kind regards


Jørgen Harsem