Copy Down Formula (assignment), Skipping Rows But Keeping Count

[AnimalMind]

Hello everyone, I have an excel question I have been working on for a few hours to no avail. What I am trying to do is assign =sheet2!A1 to sheet1!A1 then sheet2!A2 to sheet1!A4 (there will be two blank rows here A2 and A3). I then expect to drag the selection from sheet1A1:A6 down to A7:A12 and on A7 get Sheet2!A3 but instead I get sheet2!A7.

Is there a way to drag make this work?

[bebo021999]

Maybe, use this in A1:

=IF(MOD(ROWS($1:1)-1,3)=0,INDIRECT("Sheet2!A"&INT((ROWS($1:1)-1)/3)+1),"")

Drag down