Possible to make a summary page with a list of only true values on a 15 page work book?

Hey guys,
Ive gotten to a point where im not sure how to do this.
Ive gone back thru my VB book and online searchs. Im being asked to make a summary page so that if there are any quantities listed in the work book to be put on a single page so no one has to go thru the different pages.
Ill be back in a few hours to give examples of what id like to do.

Here is the workbook ive made so far.