Well, that works much better than what I had working before with a different workbook. Thanks much for that - much appreciated.

If anyone has a chance, please look at the new attached workbook and see if you can find what's wrong with the 'ConsolidateFiles' macro. Once the extraction that jindon created occurs, I want to then consolidate the data from all those previouslly extracted files back into a new sheet within the original workbook. Thanks.

File2.xlsm