Hello
I need to create a recap sheet from worksheets in multiple workbooks. All column headers are the same in each of the worksheets and all info will be coming from the first worksheet of each workbook. I have used Ron Bruin's RDB Merge and it works great but I have to select the files needed and run it several times for files located in different folders. I need to extract data from 8 worksheets in three differnet subfolders but each subfolder contains up to 50 workbooks. I only need the data from a 2 to 3 workbooks in each subfolder and it is the same worksheets every time. Would like to just run the macro with the filepaths already coded inot the macro so I do not have to choose each time. Any help is greatly appreciated.

Range I need to extract: cell b2:f last used cell

I need to pull data from the following

C:\Documents and Settings\Jones\My Documents\Customers\East\[Times.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\East\[SmartSource.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\South\[Economy.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\South\[Swift.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\South\[SmartSource.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\North\[Times.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\North\[NewStyle.xlsm]Sheet1
C:\Documents and Settings\Jones\My Documents\Customers\North\[Extras.xlsm]Sheet1