Modify IF statements in a range using a macro

I have 30 cells in a worksheet named "List". The cells are arranged in a row from Columns C:AF. Each cell contains a IF statement containing a cell reference in Sheet1 (same workbook). I want to copy the IF statements and insert them into a different row with all the same arguments EXCEPT increase the sheet reference by 1. Can this be done? Below is a sample of the IF statements in Column C:E

=IF('Sheet1'!$I$26="",0,'Sheet1'!$I$26)
=IF($C3=0,"",IF('Sheet1'!AM40="",0,'Sheet1'!AM40))
=IF($C3=0,"",IF('Sheet1'!AP40="",0,'Sheet1'!AP40))

In the example above I want to copy the IF statements and change the reference to Sheet1 by one to make it Sheet2 and insert the new IF statements into a new row. Later the same process will extend to newer rows with references to Sheet3, Sheet4, Sheet5 etc. etc.

Thank you,

PCI Brilliant!! Such an easy and simple way to work around the issue. You are fabulous!! Thank you!