eliminating duplicate email addresses

I have multiple spreadsheets with some duplicate email addresses - Is there an automated method to eliminate the duplicate rows when merging multiple spreadsheets ?

Select the row or rows you want to change then “right click”, then go to “Selection list” click on “Stanard Filter” click on “Options” and then click on “No Duplications” and set the Conditions and it will do the rest.