Formula in Array

Hi, I have an exciting worksheet that I am trying to make adjustments to.

Here is what I would like to do:

I have 5 worksheets in the workbook, the fith worksheet is a summary sheet of the first 4.

I am trying to add columns to the fith sheet so that it has the same number of columns as the other 4 worksheets.

In the first table of the Summary sheet, I would like to have the figures for the current week. And the second table would have the total figures todate.

In adding the columns, it is telling that I can not make changes to an Array.
I am also trying to copy the formula from an old sales report to get the summary sheet to calculate and it is not working.

Can someone please help?

I have attached the sales report so that you can see what I am trying to achieve.