VBA or normal formula to Auto-sort alphabetically.

Hi there,

I have a large list of names that will always change. I have staff that aren't very experienced with excel so they don't know how to use the filter functions to sort a list alphabetically (as easy as it is, I know).

I want the staff to enter the names into column A of Sheet1.

On Sheet2, I'd like to have either a formula or VBA code that can automatically sort all the data from Sheet1 alphabetically.

Thanks