Indirect reference with changing cell value?

[GolfHelp]

Good Evening,

I'm trying to drag/copy-paste an indirect formula where the row value in the reference changes. Then continue the pattern over hundreds of cells. This is the general idea:

=INDIRECT("Sheet1!A3")
=INDIRECT("Sheet1!C3")
=INDIRECT("Sheet1!E3")
=INDIRECT("Sheet1!H3")
=INDIRECT("Sheet1!I3")
=INDIRECT("Sheet1!A11")
=INDIRECT("Sheet1!C11")
=INDIRECT("Sheet1!E11")
=INDIRECT("Sheet1!H11")
=INDIRECT("Sheet1!I11")

So on, so on. So, I need the column to change 5 times within the same row, then the row to change by 8 and have that repeat. Currently I'm manually changing the Cell and it's becoming exhausting as the sheet grows. I thought I could do this with OFFSET but I'm having issues figuring out how.

 

[GolfHelp]

=INDEX(Golfhelp1!$A$1:$I$54,(((ROUNDDOWN((ROW(A1)-1)/5,0))*8)+3),CHOOSE(MOD((ROW(A1)-1),5)+1,1,3,5,7,9))

Thank you so much!

 

[awoohaw]

my pleasure. If you think a post here has provided you with a solution, please mark it as the answer!

Welcome to the Mr. Excel Forum!

Best Wishes.