Autofill column,using column (skipping some cells) from another sheet

[excellover2212]

Thanks for consideration at my question...

I want to autofill values from sheet1 to sheet 2 like given below:
(Sheet 1 is source sheet.)

In sheet 2 I want
B8='Sheet1'F31
B9='Sheet1'F62
B10='Sheet1'F93
B11='Sheet1'F124
I will be thankful if any suggestions.

[Pepe Le Mokko]

In B8 enter

Please Login or Register  to view this content.

and pull down as needed

[daffodil11]

B8:

=OFFSET(Sheet1!$F$31,31*ROW(A1)-31,0)

And copy down