Here is an over simplified example of my problem

I have 2 excel spreadsheets.

The first spreadsheet has 1 column with a list of names

John, James, Steve, Richard, Bob

The second spreadsheet also has 1 column with a list of the same names, plus some MORE names.

John, Karl, James, George, Tony, Steve, Mike, Richard, Bob, Chris

I want to find the names in the first spreadsheet, and delete them from the second spreadsheet.. so that the second spreadsheet will be left with

Karl, George, Tony , Mike, Chris

Find and Select lets me do this, but only one at a time. Is there a quicker way to search for multiple names in one go.. as I have around 1000 to check - thanks.