On second sheet you must define all words and their numbers.

There can be several words that getting same number (never into 1, sometimes into 2 and always into 3) or (yes into 1, maybe into 2 and no into 3) but there can't be same words having different value (1st question Yes into 1,second question Yes into 2, third question Yes into 3).

Also, it would be nice if you could write all possibilities that you can have:

1st question -> those answers,
2nd question-> those answers etc.

Also, much can depend of how you have sorted your data.
Some example workbook would be nice.