See if this will get tou started...

=INDIRECT("'Full Survey'!C"&ROW(A1)*27)

(you may need to fiddle with ROW(A1)