In Excel 2007 -
I have two Spread Sheets.
Both have a column with 'City' names.
How can I get a resultant list of unique 'Cities' in a new sheet listed
alphabeticaly?

e.g.

Sheet 1 Sheet 2 Sheet 3
A1 A1 A1
New York Rome London
New York Paris Madrid
London Madrid New York
Rome New York Paris
Rome

Thanks
--
Confusion will be my epitaph...