Macro for alphabetizing... more difficult that it sounds

I am trying to automate a process that I do every day in which I manually re-arrange 2 columns of names alphabetically so they can easily be viewed side-by-side. This name list is dynamic and is always changing and all recurring names would be exactly the same every time.

Needless to say doing this everyday is boring and wastes a lot of time (roughly 5 minutes every day.... multiply that by 248 work days/year and you get 20.67 hours/year!!).

Please see the file I attached and you would know what I mean.

Best,

Nick