Get data from a list to evry nth row

In sheet1 I have a data table.
Data listed in B colum starting from 11th row to 30th row

In sheet2 I want to make 30 data tables , which every table contains 20 rows.
B3 cell will get data from Sheet1 B11 cell
B23cell will get data from Sheet1 B12 cell
B43cell will get data from Sheet1 B13 cell
and will go on for 30 table.

Which kind of a formula I can use for B3 cell in Sheet 2.(Because I will copy first table(B3) to B23 and B43, B63,B83.....)

Shortly every 20th cell will get Sheet1 rows in order(B11,B12,B13.....B30)

Disregard the previous one and try this to enter in cell B3:

=INDIRECT("Sheet1!B"&(11+ROUNDDOWN((ROW(B3)-ROW($B$3)/20),0)))

Originally Posted by ChemistB

Try this in B3 copied down

=IFERROR(INDEX(Sheet1!$B$11:$B$56,MOD((ROWS($A$1:$A1)-1),20)*20+INT(ROWS($A$1:$A1)/20)+1),"")
Does that work for you?

Thanks a lot.
Worked very good.

Originally Posted by jackgan

Disregard the previous one and try this to enter in cell B3:

=INDIRECT("Sheet1!B"&(11+ROUNDDOWN((ROW(B3)-ROW($B$3)/20),0)))

Thanks for reply, but did NOT work.
ChemistB reply is OK.