auto sort and hide blank row

[Afogelman]

i am attempting to create a database for a digital signage, i want it to have a list of people and there room numbers, the first tab will be what everyone can access and input info on names of people in those rooms. next tab is that same info but alphabetized and filtered so that when i use the data from 2nd tab and paste it into signage if rooms are empty they simply are not shown and no space is left for it.... now its not allot of info only about 200 rooms and i have been able to do both process but not together and not without triggering them. but i want only that first tab to have info that others change and once that is done i want the workbook to do the rest. i really feel that this is possible but i have yet to be able to make it happen. so i am reaching out because after the 6 weeks or so of looking for answers i can only do so much with the knowledge i have learned through allot of looking and trial and error