EXCEL functions, as shown in the figure, how to add alternately?

If the interval is 18 rows, please enter the following formula in the current cell.

=OFFSET (weather! C$8，INT((ROW()-7)/ 18)，)

Then copy it to other locations, and the effect that the reference cell moves down 1 row every time the C8 cell of the weather table moves down1row can be automatically realized.