Dragging Formula down through merged cells

[twmills]

In merged cells which include cell G4:
=INDIRECT("Sheet2!B" & INT(ROW()/4)+3)
copy down.

Or likewise with:
=OFFSET(Sheet2!$B$3,ROW()/4,0)

or:
=INDEX(Sheet2!$B$4:$B$8,ROW()/4)

yes. I liked the Index one.

That was perfect.

Thanks so much!