Can a cell display the text in a random number of other cells based on the status of cells in the same rows as the text? [Calibration Tracking]

The sheet has a column of names (of equipment), with dates (when calibration expires) in the same rows.

I want one cell at the top of the sheet to show the names of all equipment with calibration dates in the past.

> I have Conditionally Formatted the date cells so that any dates in the past so can be found by scrolling down the date column, but I want the cell at the top of the sheet to show the equipment names associated with the past due dates.

I'm struggling with showing an indeterminate number of names in a cell. is that possible?

Currently, there are over 200 rows. I hope there will never be more than ten dates or so in the past.

The application is a calibration date tracker.

Additionally:

I would also like to be able to enter a number which would indicate the number of days in the future to find dates in the next so many days and have the names of equipment whose calibration expiration dates which less than that number of days show up in another cell, but that should be easy once the first problem is solved. So, entering "5" would show the names of equipment due for calibration within the next five days.

Finally:

I want the sheet to always open with the top row at the top no matter how it was saved.