I have the following formula in C9

=OFFSET(Connie!$O$9,0,(ROW()-9)*2)

which is then copied to next 4 row and formula repeats with an
incremental offset, so that in Row 14 would be

=OFFSET(Connie!$O$9,1,(ROW()-14)*2)

and so on. A Few more examples

R19 would be =OFFSET(Connie!$O$9,3,(ROW()-19)*2)
R24 would be =OFFSET(Connie!$O$9,4,(ROW()-24)*2)
R29 would be =OFFSET(Connie!$O$9,5,(ROW()-29)*2)
R34 would be =OFFSET(Connie!$O$9,6,(ROW()-34)*2)

Notice how every fifth row the row offset increments by 1, and
the column offset by +5.

I can't figure out how to increment these variables accordingly. If
anyone can help with an amended formula or better yet with code, it
would make my life a whole lot easier. I have over 5000 rows to input
these formulae and copy down 4 rows. TIA