Narrowing or Expanding Questions listed based on category(s) chosen

Hello! I have a long list of safety questions that I would like to be able to have listed in a PivotTable, I think. Currently, I have the list in Word format, with any questions that are not applicable to the job being answered as "N/A" (printed/written manually on the sheet). On certain jobs, from the beginning of the job, I know that a series of questions under a certain category will never be needed, and I would like to have the option of not including them on the answer sheet at all. That is why I think a Pivot Table would be best. I have tried just adding the different categories to the "Row" field in the Pivot Table Field list, but all that gives me is the first question alphabetically, under each category in an outline type list, followed by all of the next questions alphabetically, and so on. I was hoping to have all of one category shown if chosen and then all of the next, following it. Due to the lack of actual math being done, it may be easier to just have the list be chosen by the category, with all questions under that category being listed in another sheet if the category is chosen; however, I have no idea how to make those equations do what I want them to do either. Any help in either direction would be welcome.

Thank you!

Thank you! The end result is what I was looking for.

Dflak - How were you able to get the "Question Selection" to pick up which questions went with which category? I can get a similar table to pull, but only as many lines as are in the "Category Selection" pivot table. Once it gets beyond those 7 lines, it returns a "#VALUE" error due to there not being any more categories for it to look at. Your spreadsheet seems to know which category goes with which questions.


Also, thank you for the link on dynamic ranges. That just blew my mind and will totally help with so many other spreadsheets I have.

TY
OVacctng