Excel Macro to delete row if one of 37 plus names is found

sample data.xlsHello Everyone!

I need help to create a macro to delete a row if a certain name is found in column F of sheet2. The problem is that there are over 37 names and the name format is Last name, First name the middle initial. A few of the names are even more challenging. Below are a few examples of the name format:

Rusk, Debra L
O'Donnell, Daniel P
Palmer-Smith, Victoria C
Weinstein, Elizabeth
Sequera Sanchez, Ivan D