would like to list several cells from a lookup incl. other data (vstack? hstack?)

I have a large (1000's of rows, 100's of columns) data set that is like a validation of permissions. The different columns are the different roles in the organisation, but they start at column 15 as the first 14 columns contain the access descriptions listed vertically in the rows (1000's of them).
Thus the Yes/No/NA data will start in cell O2.

The first 14 columns describing the access is because of different modules, areas, focus areas etc.

What I have is a drop down list of the roles (O1:GE1) on a new sheet) which, when each role is selected in turn from the drop down list, it will display the 14 column set of access descriptions for when that role has a Yes, and then underneath all of those, the 14 column set of access descriptions for when the role has No.

I posted the question of how to achieve this some time ago and was helped out wonderfully by people here.

New question:
I have to now add in a text field (instead of just Yes or No or NA) that needs to be listed above the yes and no data.
After each Module I'm putting in a summary (so the people using the spreadsheet don't have to scroll through 1000's of rows to get the info they need).

I can do an index/match with the Role at the top and the 'Summary' cell to display the summary text field, but I also want the leading cells before it says Summary (see attached sample spreadsheet) as well as how to list several Summaries (as some roles will have approx 80+ summaries by the end of it!)

I then need the original Yes/No listing (the red and green cells in the sample sheet attached) to list underneath the summaries. As some roles will have 2 or 3 summaries and others have 80+, it needs to be dynamic so I don't get a spill error

Does this make sense? Hopefully!

Any help would be much appreciated.
I've attached a dummy spreadsheet with hopefully clear comments about what I need.

Thanks in advance!

Thanks so much, that looks like it works perfectly! Now I'll try to adapt it for my big spreadsheet

ok, so the big sheet works, which is great, but I'd like another modification if that's ok.
If the summary is blank (eg the Role has no access to that module, and therefore no summary is written) it will still show, with a value of 0.
I'd like it to not show at all.
Is this possible? I've attached a screenshot that hopefully explains it
Thanks

That's fantastic, does the job perfectly.
thanks heaps!

sorry to reopen this question, but I'd appreciate your help again
In the attached sample spreadsheet, my yes/no data is about 10 rows. Displaying these as per my requested formulae isn't an issue. My large real spreadsheet is up to 9000 rows, and so displaying all of the yes/no's is unrealistic, so my supervisor just wants the summaries.
I can do just the summaries, based on your earlier help, for a specific Role.
What I am not sure how to do is when we have the managerial role (covering several Roles), and just wanting the summaries relevant to them. Your previous formula used Lambda and had a #REF! in it and so I didn't understand how to adapt it to my spreadsheet.
I have been able to attach x's to each relevant role included in each Manager role, but not sure how the formula works for just the summaries of multiple Roles.
I have included 2 sample spreadsheets - Mosom 6 - which shows what I would like to happen, and Mosom 7 - which shows the groupings under a managerial role but includes the yes/no's and lambda and #REF! that I didn't understand.
Can you please have a look at the Mosom 6 sample sheet and see if you are able to help me?
Thank you so much in advance!

Hi, no, it works in new Mosom 6
the screenshot, which has the #CALC! error, is from my actual spreadsheet, but I don't know why, as the formula is the same as the one in new Mosom 6