On reflection, I think you probably want 50 different values, so you
can make use of the ROW( ) function to give you the increment for your
"run" sheets. Assuming you have some description in column A, and that
your first formula is in row 3 (to allow for headings etc), then enter
this in B3:

=INDIRECT("'run"&(ROW()-2)&"'!G$1")

and copy down for 50 rows. You want the expression in the middle to
evaluate to 1 for your first row, so if this is on row 5 then change it
to:

(ROW()-4)

The apostrophes are not strictly necessary if you do not have spaces in
the sheet names.

Hope this helps.

Pete