If you are using form objects for the questionnaire, then the options will be coming from some source ranges. If you attach a cell link to the form object, then it will return the index number of the option chosen. The destination sheet then needs to take in INDEX function with the index number of the option chosen against the source list range to return the text of that option. For example, index 1 would return "male" and 2 would return "female".
