Seconday Worksheet Reference Formula Drag Fill incrementing Issue

I have 18 worksheets, in the last 17, i want to auto fill information from the first worksheet.

Scenario, sheets 2 through 18 are all formatted exactly the same and all needed data auto filled from b3 through r41.

sheet 2 b3= sheet 1 b4
sheet 2 b4= sheet 1 b26
sheet 2 b5= sheet 1 b48 and so in in a 22 cell increment. and as far as filling left to right, the columns match between sheets.

i just want to create a formula in cell b3:r3 that i can fill drag down to b41:r:41that increments in reference to sheet 1 by 22 cells .

in sheet 3, i will do the same thing except start on sheet 1 b5 and go to b27 and b49 and so on.

sheet 4 will start at b6 and it will continue all the way through stopping on b20 on sheet 18

Does this make sense?

in my lame attempts, i filled in the formula on sheet 2 b3 to say b3=sheet 1 b4 (in proper form) and i drug it to the right. I did that for the first three rows hoping excel was intuitive enough to catch my progression pattern of skipping 22 cells, but it didnt of course.

In sheet2b3 enter =INDIRECT("Sheet2!B"&((ROW()-3)*22+4)) - Pull down as needed

be aware that INDIRECT is volatile and will calculate at each change in the workbook even if the function is not addressed

My issue is the sheet b reference in the formula. My workbook is in regards to a football pool. Sheet 1 is titled "Master Picks" Sheet 2 is an independent worksheet that does not need to be referenced. Sheet 3 is title "Week 1" and sheets 4 - 19 are title Week 2:Week17.

i apologize but this is my first delve into inderect and index functions