Combine many files into a single worksheet with additional columns

Hi All,

Hope someone out there has had a similar issue, here goes.... I have a bunch of excel files (1000+) in a similar format. I need to combine the separate files into a single worksheet. The files have been formatted as a form so I don't need all of the sheet, just the data table in the middle of the sheet copied to the master worksheet. The data table in the middle of the sheet has a variable number of rows, sometimes just one and sometimes over 100. I also need to add three additional columns when the data is transferred. The source information for the additional columns is fixed to the same exact cells in every sheet, the data is the name, the date and the form number. They are in cells D8, H6 and H8. I need to pull all three of those values and add them to the data in separate columns as it is transferred into the master worksheet so I can run a pivot but name, date or form. I tried using the RDBMerge, it works great but has two configuration issues: 1) It can't be configured to determine the rows it needs to copy & 2) It can't be configured to add additional columns other the filename that it came from.

I've done quite a bit of VBA in Access, but I'm a newbie with Excel VBA, so I don't really even know where to start. Any help that can be provided would be greatly appreciated. Thanks in advance!