Copy a group of cells based upon the value of another cell

Hello,

I have a group of cells for each week of the year. I would like to be able to copy that group of cells into another area on the same sheet depending on the week selected in a particular cell. In A74, week one is selected so the black outline is filled with the values from week 1. If I then choose to process the data in week 2, I change the one to a 2 and this replaces all the cells in the black box with the contents of week 2 etc.

Put this formula in cell B27:

=INDEX($B$2:$AB$22,ROWS($1:1),COLUMNS($B:B)+MATCH($A$24,$B$1:$AB$1,0)-1)

then copy across and down to fill the lower area. Then change the value in A24 to see the other values change accordingly.

Hope this helps.

Pete