I am trying to create an excel based questionnaire. I am using the drop down buttons for users to select their responses.
However, what I want to do for the first question to guide the questions for the entire survey.

For eg. for the first question- the user is asked which state he/she lives in. Based on the response, it will determine whether it is the South, west, East, north, north east etc. So if a user selected California, he would get to answer questions related to the West Coast only. The other questions to the other regions would not populate. How can this be done?
Also, at the end of this questionnaire, I want to collate all the responses in another tab that reads like a narrative.

Any help is appreciated.

Thanks