Linking conditional data only

[mkenn]

Hi there all, does anybody know how/if this can be done.
I have 4 worksheets in 1 spreadsheet. The first 3 worksheets have numerous columns of product info. 1 of those columns has a use by date. I have used conditional format to highlight all dates that have expired.
What I would like to know is, can the highlighted items be automatically transferred to the 4th worksheet so I then have a list of the expired items only from the 3 other worksheets.