Extracting data from formatted workbook

Hello Excel Forumers!

I've got a consolidated workbook with umbrella questions, subquestions, scores, and answers, and I would like to break it up into separate sheets. I'm not sure of the best procedure to do this.

My consolidated workbook is pictured below. The source data consists of umbrella questions identified by a unique question number in yellow and a varying number of umbrella questions. Each umbrella question belongs to a category in column E (P, S, I) and is scored on a scale from 1 to 4. Those scores read from the answer choices of "Yes" and "No" given to each subquestion.

The formula that makes that work is =IF(I31="N/A","...",IF(I31="No",1,1.8+COUNTIF(I33:I35,"Yes")*2.2/COUNTA(I33:I35))), for example.

I'm looking to create a separate sheet for each category (P, S, I) while preserving the subquestions and the structure that sets the scores for the umbrella questions.

Here is what the source data looks like:

zMqgHjm.jpg

And this is an example how each of the "I" category questions should look in their separate worksheet. We can ignore columns E onward at this point.

XBy0yDz.jpg

Any ideas?