Pivot Table to combine tables on multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1716573%22%20slang%3D%22en-US%22%3EPivot%20Table%20to%20combine%20tables%20on%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716573%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20track%20my%20monthly%20shipments%20in%20one%20excel%20workbook.%20Basically%2C%20the%20way%20that%20I%20am%20currently%20tracking%20is%20using%20one%20sheet%20per%20shipment.%20Each%20sheet%20contains%20three%20tables.%20I'd%20like%20to%20create%20a%20master%20sheet%20for%20each%20table%2C%20calculating%20the%20totals%20from%20each%20on%20the%20sheet.%20Im%20going%20to%20attach%20the%20workbook%20to%20give%20an%20example%20of%20how%20it%20is%20tracked.%20I%20can't%20figure%20out%20how%20to%20get%20the%20pivot%20table%20to%20calculate%20the%20data%20from%20more%20than%20one%20sheet.%20Any%20advice%20is%20appreciated.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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