Need a list of names from a schedule to populate based on what day of the week it is and if they are scheduled to work that day.

I want the schedule above to go into a separate list that only includes people that are working that day, in alphabetical order automatically.

I don't want them spaced out on the second list, I want it neatly organized.

EX:

Formula: =SORT(FILTER(B20:B29, ISNUMBER(C20:C29), " "))

This formula only works with one column, but I need it to change based on what day of the week it is.

Thanks,