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