get distinct data from multiple sheets & then consolidate distinct

[Nikhil]

I have data in a table in multiple worksheets... I would like to consolidate
the distinct data from these sheets into a single sheet....

eg. sheet1- A-B-C
sheet2 - X-Y-Z
sheet3 - A-B-E
sheet4 - X-Y-Z

the result should be :

A-B_c
X-Y-Z
A-B-E

this is to be done using a macro...

plz help..

 

[Tom Ogilvy]

Use the method shown here:

http://www.j-walk.com/ss/excel/tips/tip47.htm

although this is for filling a listbox, the concept/approach presented does
what you want