Top level: I'm looking for a macro that can use the consolidate excel
function on Multiple Workbooks and Sheets based on either file
location/file name (or if you have a better idea I'm open).

All of my workbooks/sheets (based on the same tab name) have identical
row and column structure, but they are located in different folders
(some folders have 2 some folders have 10). What I want is a macro
that will consolidate all the workbooks in one folder into a new
summary file and move to the next till they are all done.

Thanks,

T