Drag Sequence having sheet reference

[am_hawk]

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!

[oeldere]

a1

=INDIRECT("Temp_Data!"&"A"&1+(Row()-1)*4)

and drag down

[am_hawk]

Thank you, it worked as expected. I appreciate the time you took to answer!

[oeldere]

Thanks for the reply.

Glad I could help.