Hi
in A1 enter
=INDIRECT("'sheet" & ROW() & "'!F1")
and copy down

"electromott" wrote:

In a fill series how do I increment the sheet number but not the cell i.e.
sheet1!F1, sheet2!F1, sheet3!F1 and so on.