#consolidation

How to merge hundreds of workbooks without writing a macro

Monthly branch reports, regional exports, one file per client. Here is how to consolidate them reliably, including the header-mismatch problem nobody warns you about.