I am trying to copy a formula with a relative reference in one worksheet to
another worksheet but the relative reference does not change as it should.

For example, I have '1' in cell G1 on sheet A.
On sheet B, in cell G1, I have a formula "='A'!G1+1".
This should give me 2 in cell G1 on sheet B.
I tried to copy this formula to my other sheets which in theory should give
me 3, 4, 5, etc. However, instead of the formula adjusting to the previous
sheet, the formulas copied all refer to sheet A and I get 2 every time.

I have over 100 sheets I need this for and don't want to have to edit every
formula. Is there a way to copy relative reference formulas to different
sheets and have the reference adjust as it does when it is on the same sheet?

Thanks.