I have a spreadsheet where I download company production data from 2 sources. I use pivot tables to extract production data (Produced, Scrap, types of scrap, etc.) I have charts that uses GETPIVOTDATA formulas to get specific information about a part. I need to combine results from the 2 pivot tables. (scrap data from our plant + scrap data from another plant). It is the same part numbers, just different stages of the process. The fields of the pivot tables are exactly the same. (Filter =scrap, Column=TDATE-Month, Rows = 5digitnumber and Cshift, Sum of values = TRQTY ( which means transaction quantity). Example of a formula using one pivot table is: IFERROR(GETPIVOTDATA("TRQTY",'01 - Data Sheets'!$F$5,"5DigitJobNumber",08845,"CSHIFT",1),0). $F$5 is the pivot table location, and 08845 is the 5digitnumber of the part, and Cshift is the shift producing the production/scrap. How can I add another pivot table location $P$5 to this formula to get 1 result. Example of some of the results of formulas: