Let's say you're displaying your results in a column starting with row 1,
then you could use this:

=INDIRECT("sheet"&row()&"!F10")

If you wanted to start on row 5, then just subtract 4 from the row() function:

=INDIRECT("sheet"&row()-4&"!F10")

Or, if you wanted to display the results in a single row, then use the
column() function rather than the row() function.

HTH,
Elkar


"Kim" wrote:

I am trying to list from 100s of sheets a number so I go to lets say F10 on
sheet 2 (sheet2!f10), (sheet3!f10), (sheet4!f10). How can I drag and copy so
sheets change?