Need suggestions to tally weekly totals

Hi guys

I have a waste sheet which tracks week by week, at the end of the week, the sheet is saved into an archive folder and reset ready for a new week.

I have a macro that already runs to copy and paste totals onto a sheet so we can see week by week whats going on.

But now i've come stuck, I need a total, week to date on some figures which i'm not sure on how to go about?

On my "Total Cardboard Waste" I have in column B, all the types of boxes.
C to AV colums, lookup B and return figures from 4 different input pages which is totaled in AW.

So on a saturday night, when the cleardown macro is enabled, i need to:

use the totals in AW3,AW4,AW5....... and paste them somewhere as a value. The following week, I need AW3,AW4,AW5 and so on, copied, and added onto the pasted figures from last week so I get a total tally each week.


Example. AW3 in week 1 would be 0 so this figure would be pasted into BA3, following week figure from AW3 would be added to BA3 then pasted as a value, Week after iAW3 figure would be added to BA3 and pasted as a figure and so on.

Any ideas on how to go about this?