Extracting details from a row that matches criteria and inserting into another sheet

[atombomb99]

Hi Everyone,
I don't usually get stumped with an approach solving a problem, but my brain must be on strike today!

I'm uploaded 3 images to show what I'm trying to work out as it might be easier.

Screen1.jpg is the source data. The names are generic names, but take for example the person called "User, testing" on row 6.
They have to do mandatory training every 30 days. Renewable dates for each course (Basic Food Hygiene, Fire Training) etc have dates they have to be done by.

The sample record I'm working on to keep it simple is staff member "User, testing".
I want to extract everything in B6:I6 where the date is 'missed" (ie the date under the course is in the past, which means it hasn't been completed).

I'm put a choosable list box in another sheet with a dropdown pulling the "staff member" ok (screen3.jpg) , and I'm trying to show just the 'overdue' ones in a simple list like this under the name as in screen3.jpg rather than the whole list again.

I only included screen2.jpg for information on summary statistics (ie "User, test user") has 5 occurrences with dates in the field in the past of 5 courses that need listing.

I went down a complicated array route I found but then my brain melted, so wondered if anyone has any ideas.

Any help greatly appreciated,

Best Regards,
Paul