Bernie Deitrick wrote...
You have lots of options:

=INDIRECT(ADDRESS(1,ROW(A1)))

Better to skip the ADDRESS call and just use

=INDIRECT("R1C"&ROW(A1),0)

=INDEX($1:$1,ROW(A1))

Much better since there are no volatile function calls. However, it's
easy to generalize this so the formulas could start in any row. If the
topmost formula were in cell X99 and should refer to cell A1, with X100
referring to B1, etc.

X99:
=INDEX($1:$1,ROWS(X$99:X99))