merge sheets in one master sheet

[Crispy85]

Hi Folks,

I have this file with a nice script (i didn't write myself because i'm n00b).
But it works: It puts all the excel files from a folder into this sheet.

The macro is activated by the button in the sheet Combine.
In my example, the macro already ran and it created 1. xlsx 2, 2. xlsx 2, 3. xlsx 2, 4. xlsx 2.

Now i'm stuck and i cant find a solution on internet

What i want is that it consolidates the information from these 4 new created sheets and puts them in the sheet "Consolidate".
After this, it should remove all sheets except "Combine" and "Consolidate".

Offcourse, in reality these sheets will be bigger with headers and such things. So it should copy this range. Maybe something like xl end to right.

Can somebody help me out?

Regards,
Crispy

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.