=INDIRECT("'sheet "&ROW()&"'!F13")
--
David Biddulph

kiboypalaboy wrote:
hi sheloo,

how about if you if refer multiple sheet but the same cell that u
want for.. like i want the cell F13 for sheet 1 up to sheet 1431..
and if input the formula for new worksheet in
A1=sheet 1 F13
A2=sheet 2 F13
........
A1431=sheet 1431 F13

thanks in advance for help