Require to select conditional formatted cells from different sheets and show on a seperate

Dear Sirs,
Good Day!
Attached is an excel file containing sheets for a planned maintenance system for a ship.
As you will note that the fields in the last column of every sheet have been conditionally formatted to change to either an orange or red color, to show if the item is coming due or is overdue for maintenance.
I would like to insert two other sheets, to be named as a PMS Overdue for items that are highlighted red and another sheet named as PMS Coming due for items that are highlighted in orange.
I require your help in the folllowing:
- Making or listing a Summary of the items coming due and overdue, from the other sheets, so that the end user, does not have to scroll through every sheet to check items that are due or overdue.
Thanks in advance for your help.
Warm Rgds
Rohann