Copying formula - dynamic worksheet reference

Is it possible to copy a formula and have the worksheet name increase incrementally instead of the cell reference?

Example: In column A, I have the following -

=TDI_SR_F_1!$G$1
=TDI_SR_F_1!$G$2
=TDI_SR_F_1!$G$3

I want to copy this across to column B, but instead of just copying that exact foruma across I am wanting a formula that will update the worksheet reference to:

=TDI_SR_F_2!$G$1
=TDI_SR_F_2!$G$2
=TDI_SR_F_2!$G$3

TDI_SR_F_2 is the worksheet after TDI_SR_F_1.

NB - I cant use find and replace function as it will change the '1' which is part of the cell reference ($G$1) to a 2 as well. I know I can use TDI_SR_F_3 as a search string, but the process is going to be extremely tedious, i.e. there are literally over 100 rows I need to do the find and replace on.

Example formula:

=INDIRECT("sheet"&COLUMN()+1&"!$G$1")