I need a formula that I can copy forward and will move the coulum refrence
backwards ie, the data I have is in colums G,F,E,D,C,B,A and I need it
referenced in another sheet A,B,C,D,E,F,G. So A=G,B=F, C=E and so on

It is a simple cell reference but it is for a very large amount of data, so
I need a formula that will be able to update the colulm refrences going
backwards when it is copied across the row.