title: How to sum row grand totals of corresponding fields from multiple pivot tables on different sheets?
body: <p>I have multiple 3 different pivot tables on 3 different tabs. Each pivot table contains a field called "Period" (a column, thus each Period is a row). Each "Period" has multiple "Ports" (again columns). I then have the Grand Total column - which is just the sum of the "Ports" per period.</p>
  
  <p>The "Period" field is dynamic, as time moves on the Periods may change and there may be 3 periods one day, 10 periods the next (i.e. 3 rows deep today, 10 rows deep tomorrow).</p>
  
  <p>Every pivot table is presented in the same way. The rows in the "Period" field may be the same across all 3 worksheets. Example:</p>
  
  <p>Sheet1</p>
  
  <p>Period..........Grand Total</p>
  
  <ul>
  <li>Jan 23-27 (Grand Total = 10)</li>
  <li>Jan 30-03 (Grand Total = 5)</li>
  </ul>
  
  <p>Sheet2</p>
  
  <p>Period..........Grand Total</p>
  
  <ul>
  <li>Jan 16-20 (Grand Total = 15)</li>
  <li>Jan 23-27 (Grand Total = 15)</li>
  <li>Feb 6-10 (Grand Total = 5)</li>
  </ul>
  
  <p>Sheet3</p>
  
  <p>Period..........Grand Total</p>
  
  <ul>
  <li>Feb 6-10 (Grand Total = 10)</li>
  </ul>
  
  <p>I want to output to a Range, on a 4th sheet, that shows:</p>
  
  <p>Period..........Grand Total</p>
  
  <ul>
  <li>Jan 16-20 : 15</li>
  <li>Jan 23-27 : 25</li>
  <li>Jan 30-03 : 5</li>
  <li>Feb 6-10  : 15</li>
  </ul>
  
  <p>As the totals change and the weeks change, the addition should always be done. I also want to easily add more Pivot Tables when necessary. Hope that is clear enough.</p>