Import Data From Multiple Workbooks To Another

[Jorrg1]

Hi

I have a macro that can import data from the first sheet in several workbooks into a single Workbook. The name of the workbooks (company A and company B), is linked to the sheets in the Master workbook, named "Macro". Please see the attached files.

The problem is that the macro only imports the first sheet from the workbooks (company A and company B). I want to be able to import the "import this" sheet, or at least to sheet number 3 from the workbooks.

Can anybody help me with this? I will be very greatful. Many thanks

kind regards


CompanyA.xlsxCompanyB.xlsxMacro.xlsmCompanyA.xlsxCompanyB.xlsxMacro.xlsm

[Jorrg1]

I solved the problem

[Excel Fox]

Jorrg, could you share the solution with us. Might help the other visitors.