I have a list of names that i want to be able to add to and keep at its
current location, but I need it to alphabetize the list automatically. I
certainly know how to do this "manually," but I have multiple lists that need
to be reordered.

To make matters worse, I really actually need the alphabetized list to be in
a new sheet, outside the original workbook.

Thank you for your help!