Drag down which skips every 8 rows

Hi,I have a problem with the drag down.

I have value on Survey1 in column B and I want to drag down in Sheet1 but skip every 8 rows meaning that

Survey1 Cell B2=Sheet1 Cell C2-C9
Survey1 Cell B3=Sheet1 Cell C10-C17
Survey1 Cell B4=Sheet1 Cell C18-C25

I use this formula but it does not work.

=IF(MOD(ROW()-4,8)=0, INDIRECT("Survey1!B" & 8+((ROW()-4)/8)-2), "")

Could you please help me solve this issue. I also attach the file in this post
Thank you

Hi Richard, it works perfectly. Thank you very much