Existing Pivot Table need to extract data from multiple tabs

[Grimm127]

Hi Excel Gurus

I currently have an existing Pivot table. I have been looking on line to find a way to have the existing pivot table to look into multiple tabs. I already have the tabs named. The only thing I found at this point is how to create one from scratch. However, I don't want to do it this way because I have several calculated fields and I don't want to create these fields gain. Is there a way to do this?

Using Excel 2013 btw

Thank you!!!!

 

[oldbrewer]

can you import the data from multiple tabs into your tab (where the pivot table is)

 

[Grimm127]

What di you mean Import? If I go to Pivot table Tools - Analyze - Change Data Source it only allows me to add one table only even if I try to use a comma between the two tables. If I just add one data source and go to the PivotTable Fields, I don't see the Add feature. So how do I get there?

 

[oldbrewer]

If you have data on say sheets 2,3 and 4 you can "import" that data to sheet1 by say in A1 = sheet2!A1

and in B1 =sheet3!A1 so the other sheets are not altered but a copy of your data in in sheet1 where you can set up the pivot