Combine Multiple Worksheets into One with Append Query - Excel
AWESOME Excel trick to combine data from files with DIFFERENT headers
How to Combine Multiple Excel Sheets or Workbooks Seamlessly
Consolidate & Clean Multiple Excel Sheets in One Pivot Table