how to create one pivot table from multiple tabs
- 1. Click Insert at the top of the screen. 2. Click the PivotTable button on the Ribbon. 3. Select the first table you want to add to the pivot table. 4. Check the box labeled Add this data to the Data Model and press OK. 5. How to Create a Pivot Table Based on Multiple Tables in Excel 2013 2. Click the PivotTable button on the Ribbon. 3. Select the first table you want to add to the pivot table. 4. Check the box labeled Add this data to the Data Model and press OK. 5. Click All in the PivotTable Fields window to view all of the tables.