aahh ok, gotcha

If this works...
=IF(INDIRECT("'Full Survey'!B"&ROWS(B3:B3)*31)="","",INDIRECT("'Full Survey'!B"&ROWS(B3:B3)*31))

Then adjust it to this...
=IF(INDIRECT("'Full Survey'!B"&ROWS(B$3:B3)*31)="","",INDIRECT("'Full Survey'!B"&ROWS(B$3:B3)*31))
and copy down

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.