Evening everyone - apologies if I'm posting in wrong place but am new to all this!

I've got a problem where i have to summarise product transactions. I have set up a pivot table (lovely jubbly), but due to the number of monthly transactions not being able to fit one worksheet (not enough rows), I am having to extract weekly raw data and use pivot tables to summarise.

Now I need to find a quicker way of adding the weekly summary data from the pivot tabs together to make a monthly summary (currently having to do it manually ugg). I did try having a master sheet which summed cells in the pivot table worksheets but unfortunately the weekly pivots don't always have the data on same rows (ie apples transactions in week 1's might be on row 4 but in week 2 might show on row 6 - due to the source data being different each week)

Hopefully this makes sense as I don't have an example available at the mo. Any advice would be fab. I love these forums

Cheers
B