How to Create a Pivot Table from Multiple Worksheets

1. Open the workbook in which you want to create the PivotTable.
2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.
3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.
4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.
5. Click the black box on the right-hand side of the source box again to attach the box back to the wizard. Click 'Next' in the wizard until you reach the end and then click 'Finish' to exit the wizard and create the PivotTable.