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

=VLOOKUP($B$8:$B$15;July_2009!$B$9:$C$24;2;FALSE)

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.