Need help removing entries, without merging filed

I have three files of contact information with fields like

e-mail, name, phone etc.

One file has approximately 52,000 entries, which is the master list.

I have two other files of people who have unsubscribed and have bad e-mail addresses.

I need to remove all the in those two files that are on the masters list--but I do not want to merge the names that are not on it.

In other words, I do not want a single name that is on either of the two smaller files to be on the master list.

Any help would be appreciated.
Thank you

Are macros an option for you, or must your workbooks be macro free?

If they must be macro free, then you could use a helper column to do a match/lookup in the two smaller files. If a match is found, return 1 or something. Then sort your master list by the helper column, delete everything with a 1, and you're done.