Is there any way to extract the detail listed in drop down auto filters?

I work with files where there are numerous entries of the same customer name
for each customerustomer in the one list along with other data in the file.
When you select the drop down box in the auto filter you get a list of
customers. It's that list that I want to put on another worksheet so that I
have only one listing per customer rather than 20 or 30 of them.

Or, maybe there is a better way you fine people might suggest.

Cheers
Mark