Track expired items in separate sheet

Hi,
New member here, just starting to figure out the wonders of excel and hoping someone can help me. I am trying to track medications stocked on our ambulances. We have 7 ambulances each is a separate sheet. The list of medication names is column A, and the expiration dates are listed in columns B-I (as we carry up to 8 vials of any given item). I already have the conditional formatting set up to highlight different colors 30 days prior, 14 days prior etc. in each sheet, I would like to create a separate sheet that will list items expiring in next 14 days and their location (basically, the sheet name). Not sure how to go about doing this. I am also unfamiliar with any other kinds of 'code' other than formulas that are entered into the excel program.

I am attaching the sheet I have set up so far,
Thanks in advance for your help

Expiration Dates.xlsx