Microsoft Excel Combine Worksheets with Power Query
Microsoft Excel's Power Query makes it easy to combine multiple Excel tables, from different worksheets, into one master list. You can then use that master list to create your PivotTables and summarize the data.
Make sure you download the exercise file used in the video to follow along.
DOWNLOAD: Exercise File -- RegionalData-01.XLSX