Pivot Table to combine tables on multiple sheets

Occasional Visitor

I am trying to track my monthly shipments in one excel workbook. Basically, the way that I am currently tracking is using one sheet per shipment. Each sheet contains three tables. I'd like to create a master sheet for each table, calculating the totals from each on the sheet. Im going to attach the workbook to give an example of how it is tracked. I can't figure out how to get the pivot table to calculate the data from more than one sheet. Any advice is appreciated. Thanks!

0 Replies