Copy info alphabetically

[That's Confidential]

In column A of sheet 1, I have a list of names. Likewise, I have a list of
names in column A in 12 more sheets in my Excel doc. Now, in a new sheet
(sheet 13), I would like all these names copied over and listed
alphabetically.

Any ideas?

 

[Frank Kabel]

Hi
if this is a onetime operation simply copy all ranges in one sheet and
sort them manually (Data - Sort). But maybe I'm missing something here