Hi there, im wondering if it is possible to fill a series of formula down a Column so the sheet it is referencing is in series but the cell reference stayes the same.

i.e. in cell A1, formula reads =Sheet1!$C$3,
then in cell A2, =Sheet2!$C$3,
cell A3 =Sheet3!$C$3 etc.

another example;
In cell A1, =IF($B3=0,"",IF(Sheet1!$A$20="","",Sheet1!$A$20))
cell A2, =IF($B3=0,"",IF(Sheet2!$A$20="","",Sheet2!$A$20))
cell A2, =IF($B3=0,"",IF(Sheet3!$A$20="","",Sheet3!$A$20))

Thanks.