I have a 100 sheet workbook, each with dates.I did conditional formatting to highlight expired dat

I need a way to view the expiration dates for each sheet without having to click through the entire workbook.
Is there an email alert or notification that i could set up?
or have all the highlighted dates transferred to a single sheet.