How to Create a Pivot Table From Multiple Excel Worksheets

1. Open the Excel workbook you want to insert a pivot table in.
2. Press 'ALT D P' to start the Pivot Table Wizard.
3. Select 'Multiple consolidation ranges' when the Pivot Table Wizard asks which type of data you want to analyze. Click 'Next.'
4. Choose whether you want the pivot table to have one or more page fields and click 'Next.'
5. Use your mouse to highlight the ranges you want to enter on the pivot table. Click 'Add' after selecting a range from each worksheet.
6. 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.'