Summary of "some lines" of text on the last page of a workbook.

I need two summary sections on the last page (S page), where it lists the text on the pages of a workbook,
but only items in the D columns, and only when a D, is just left of the test column. (then there
would be another summary section, for items in the D columns with a M, just left on them.
See the attachment (Also see my comments in red on page 4, and the last page "S".)

I also included my old formula (page S), I was using when this workbook was not "multi sheet" (Just one long
sheet with many pages). It worked fine.

Can this be done, or something like is, in a "multi page workbook" where a summary can still be done?
Any help is greatly appreciated. (feel free to change the workbook / add code, as I an a newbie to these
complex codes and formulas)

Thanks in Advance.

Rich, To give you some context.
This is a report used in the field with a tablet, there are a lot of just Xed boxes reporting on varies items.
That part all works fine and is not really any issue. I just need some way of being able to
"choose" some lines of text in column D of each page, that will appear in a last "summary page".
Nothing complex, just a summary of some of the text.

Sorry, You.

To Rich or FDibbins,
Are there guys that I could "pay" to help design / write a better workbook?

Its really just "Text", that will be in columns D of each page.
That's really all it is no, major "Data", No calculations.
I just need to be able to make some of the comments of text, (in D colums) show
up on the last, summary page somewhere.
The rest of the report is just "checkboxes" that work off of VBA
(You'll note that almost every column in the workbook has a "hidden column" next to it.
(When the hidden cell has a "q", in it, the cell to the right just becomes a "clickable
cell". When "clicked on" VBA puts an X in it. (See workbook) (That all works great)
I just need a summary section on the last page showing some of the "D" column text entries.
A cell in the D column (maybe on sheet 4) may say something like
"~ There is a major safety issue at the heat exchanger on floor one".

I would want to be able to "check this" somehow to show up on the summary page.
See my worksheet.