Try using advanced filters. Check the box that says "unique only" and
use copy. I usually put the location somewhere hidden or on a separate
worksheet (if you want to use data validation with data from another
worksheet you must use a named range). If you need the list to always
remain up to date you will need to put some VBA code in.