Consolidate Spreadsheets for Excel consolidates Excel sheets with a few clicks. It just needs the list of file names and optional consolidation rules may also be adapted to increase flexibility.
Key Features of Consolidate Spreadsheets for Excel include:
Consolidates Excel sheets with no parameters.
Add Excel files by drag and drop, or use the standard file dialog.
Get the Total and all the details on the same sheet.
Keeps most formulas (see the help file for more details).
Add or remove files and get the new results.
No need to select sheet by sheet and cell by cell.
No macros.
Automatic grouping of sheets.
Built-in default consolidation rules (can be overridden).