Now we can see the Pivot table and Pivot Chart Wizard – Step 1 of 3 as shown below.

Alt + D is the access key for MS Excel, and after that, by pressing P after that, we’ll enter to the Pivot table and Pivot Chart Wizard.Ĭreating a Pivot Table with Multiple Sheets To create the master pivot table from these different worksheets, we need to enter into the Pivot table, and Pivot Chart Wizard this function was disabled in earlier MS Office versions, but we can access the same by the short cut keys Alt + D + P. Here the data shows the product sold by this shop in the respective years. We have data for the year 2015, 2016 & 2017, and we are also making sure the given data has identical columns, category and sales counter. The above data are in a single workbook and in multiple sheets we have given the name of the sheet respectively to the sales year. They have this data on a yearly basis as shown in the image below, we are taking three years of data with only three columns in which one is using to identify the particular sheet. You can download this Pivot Table with Multiple Sheets Excel Template here – Pivot Table with Multiple Sheets Excel Templateįor instance, let’s assume that we have data from a shop that is selling computer parts, like Keyboard, Mouse, Hard disk, Monitor, etc.

How to consolidate data in excel 2016