OK, before do anything with this can you just clarify what you want and what I can see?

1) Are you saying that what you are asking for, is to take the data from raw data rows 22 onwards and transpose it in the same location i.e row 22 becomes column A starting at row22, row 23 becomes column B starting at row 22, row 24 becomes column C starting at row 22 e.t.c.

2) then is sheet Oak Flats E11, cell B23 idirectly references raw data cell A22 and so on for the rest of the cells in raw data

Is this correct?
(Probably more questions to follow)