removing duplicate entries in multiple worksheets

[monkeytrader]

i have a list of email addresses in the first column on 10 worksheets. some
of them are duplicates. is there a formula to compile a list of all of the
emails from all of the worksheets without showing duplicates?

ex: (e-mail address removed) is in sheets, 1, 3, 7, and 10

i would like to show only one list where (e-mail address removed) is only outputted
once.

i think this is a vlookup function, but i read that there is a 7 worksheet
maximum lookup?

thanks for your help in advance. hope someone can help.

 

[Teethless mama]

Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/3000-2077_4-10423159.html

....then use this formula

=INDEX(UNIQUEVALUES(THREED(Sheet1:Sheet3!$A$1:$A$100),1),ROWS($1:1))