Hi there I would like to achieve the following however I am encountering some setbacks!

I would like this formula to increase down the column as follows:
=Temp_Data!A1
=Temp_Data!A5
=Temp_Data!A9

Sequence is addidng 4 each time... Dragging results with:

=Temp_Data!A1
=Temp_Data!A5
=Temp_Data!A9
=Temp_Data!A4
=Temp_Data!A8
=Temp_Data!A12

I have seen the following work for others:
=INDEX(A:A, (ROW()*2)-1)

Can this be used to solve my issue?

Can a macro be created to store the number as a variable and loop a certain amount of times adding four to that variable every time?

Thanks in advance for any help!