Assuming data starts in A3 then try

=OFFSET($A3,INT(ROW(B8)/4)-2,COLUMN(A3)-1)

VBA Noob