How to Create a Pivot Table From Multiple Excel Worksheets
Excel is a spreadsheet program you can use to analyze data and create reports. One type of report you can create using Excel is called a pivot table. A pivot table takes a range of data and creates a report that you can easily modify to make the data easier to analyze. If you have ever created a pivot table using Excel, you may have noticed that you can only select a range from one worksheet. But you can create a pivot table using data from multiple worksheets using the Pivot Table Wizard.
Open the Excel workbook you want to insert a pivot table in.
Press "ALT + D + P" to start the Pivot Table Wizard.
Select "Multiple consolidation ranges" when the Pivot Table Wizard asks which type of data you want to analyze. Click "Next."
Choose whether you want the pivot table to have one or more page fields and click "Next."
Use your mouse to highlight the ranges you want to enter on the pivot table. Click "Add" after selecting a range from each worksheet.
Click "Next" and select where you want to place the pivot table. You can insert the table on a new worksheet or on an existing worksheet. After choosing, click "Finish."