Consolidate multiple worksheets into one PivotTable in Excel - Microsoft Support
Make Pivot Table from Multiple Sheets in Excel