Extract data to multiple rows based on value in separate cell

[jehster1]

Hi all,

I'm familiar with basic Excel but after 6 hours this is just beyond me It should be straightforward but I've been trying every formula I could find and I just can't get it right.

What I want is for when I change the Call Time on the LO Security sheet (D8), for it to auto-populate the names in list form in column B under Name.

The names come from the Employees sheet column B and should correspond to the call time on the same sheet in column E.

ie. when I put in 7:00 AM on the LO Security sheet, it should look on the Employees sheet and pull every name that should be in at 7:00 AM according to the Call Time on the Employees sheet.

The best I've gotten so far are blanks and #NUM errors.

I've included a sanitized workbook with the relevant sheets.

Thanks in advance!