Make a list without blank cells

Hello,

*Attached is my example*

SETUP: On sheet1 I have 7 columns. One for each day of this week. On sheet2 I have pasted a copy of my schedule with sensitive data removed.

GOAL: My goal is to populate only a list of people that are here for said day in sheet1. To clarify, on sheet1 in column B should only list the people that are here for Jan-24. That is the easy part. The part that I am having trouble with is populating that list without any blank cells. For example if I input the formula:

=IF(Sheet2!E3="WO","",Sheet2!A3)

into sheet1 cell B3 and copy the formula down, there is a gap between "C" and "H" because they are off work that day. So my formula needs to be able to recognize that they are off and skip them and list the next person. I am currently using Shif_Dur to determine if they are off or not.