Help combining text column from multiple worksheets into single column, single worksheet?

I've got an abbreviated sample file attached. I have an Excel file containing multiple worksheets, each with a column of text information (names of people). The number of names in each worksheet varies. I want to copy those names from each worksheet into a single, new worksheet. Ultimately, I want to alphabetize that single column as well as eliminate the duplicate names, such that I end up with a list of all the unique names from the multiple worksheets. Seems relatively complex to me, but hopefully not so much to more experienced users. Thank you.

I believe the easiest way of getting your results would be to use a macro, which many users on here are sure to be able to create for you.