OK - first impressions are that you are making a rod for your own back here.

In my view, having separate tabs for each week is a no-no. All of the collated data should be accumulated in one simple table, one row per 'transaction'. Then you can pull data from this one central table into all sorts of summary tables at will.