Use formula to auto sort cells in range with blanks at bottom or ignored

Hello,

I am trying to ultimately have ranges of cells sorted alphabetically to be used in drop down lists. Let me explain what I have in my attached example, and then will explain what I need help with. I have three sheets, Employee Roster, Server Availability, and Scheduling Input. In the Employee Roster sheet, I just enter each employees information. Their names get brought to the second sheet, Server Availability. On this sheet, I indicate which shifts the person can work. On Scheduling Input, I would like drop down lists alphabetized and showing only those employees who have indicated they are available.

The problem I am having is getting to an alphabetized list with the names on top. You will see in columns Q-W that I have the data of those available. In columns Y-AS, I use formulas to get the data alphabetized. In columns AV-BB, I show the actual alphabetized data. All the rest of the columns are some attempts to accomplish what I need.

My ask is this: If it is possible, to automatically sort data in columns Q-W, that would be great. If not, to be able to have alphabetized lists with names on top in columns AV-BB or columns BD-BJ.

Thank you for the help. If I've not explained something sufficiently, please let me know and I will try again.

Thanks.

Thanks for the help BMV. I will probably go with the AW option to ensure there is no lag from being an array. I've never used the AGGREGATE formula, so I'll have to research that one more. I've tested it out and can get the drop down list working, so I think this is the best answer. If something comes up, I'll post back on here. Thanks.