OFFSET and INDIRECT

[AirgasRob]

Is it possible to use INDIRECT in a OFFSET formula?

Here is the formula =OFFSET(Sheet1!$B$29,,ROWS($1:1)-1)

I would like to replace $B$29 with =INDIRECT($F$1)

 

[David Biddulph]

In which case =OFFSET(INDIRECT("Sheet1!"&$F$1),,ROWS($1:1)-1)