Copy range every workbook and match data

[Zaeguzah]

Hi guys. I have a new problem and I hope someone can help me out with this. The workbook below in the attcahment contains a macro made by Ron de Bruin which copies a specific sheet from every workbook in a specified folder.

The workbook is configured as below:
- first sheet is the sumary
- the other sheets are imported by the macro

Each sheet imported by the macro will have the name as folows: month_year. In the sumary sheet I have a table that will contain the totals and the name of each sheet copied.

I need to edit this code to do the folowing:
• place the sheets in the current workbook as values
• place in the sumary sheet row 6 from column "D" and up the name from each sheet.
• autofill

Please Login or Register  to view this content.

until the last used cell in column "B". Adjust the sheet reference with the current sheet name in row 6.

Basically for each sheet imported I will need the name of the sheet/s in row 6 and their values matched with the vlookup formula.
Thanks for looking into it.