This formula works assuming your data starts in A!A1 and you want to
return every sixth cell starting in B!B1:
=OFFSET(A!$A$1,ROW(B1)*6-1,0)

This uses A!A1 as the starting point, and multiplies the row number of
this formula by 6 and subtracts 1 for the row offset.