How to autofill in certain way??

Hello everyone
So I want to autofill in a certain way. I want to fill the data in this way. first I press = sign then go into a sheet and select B3 so my formula comes out to be (=sheet!B3) right. Then I do it again and select B8 then I do it again and select B13 now I want to drag this vertically so that it selects B17. As you can see B is constant and there is 5 cell gap right, but if I drag it to take data C3 and not B8.

So, is there any way that if I drag the autofill in a certain way like if I drag B3 then the next cell it should select should be B8 is there any way plz help

You can avoid the volatile function OFFSET, by using INDEX instead. Put this in your first cell:

=INDEX(Sheet2!B:B,(ROWS($1:1)-1)*5+3)

then copy down as required.

Hope this helps.

Pete