I copied a large amount of data from Sheet 1 and transposed it into Sheet 2
so I could create a pivot table.

Now I would like to link the similarly valued cells together so that I only
have to enter a value once in sheet 1 so that it updates in sheet 2 to link
to the pivot table

Sheet1ActualSalesWeek1= Sheet2ActualSalesWeek1 etc

I can do this manually but it is very long and laborious. Because one sheet
is transposed I cannot click and drag and when I attempted a macro I
encountered a bug.

I would be grateful for any suggestions