Delete rows in data where column B doesn't meet criteria

Hi,

In the attached example, I have a list of Basketball matches in column B and what I want to do is reduce the list (by deleting unwanted rows, not filtering) to matches that just contain NBA matches. The full version of my data will contain thousands of rows so you can imagine this will save me a lot of hard work not manually go through each row.

In the worksheet 'Team List', I have a list of the team names to verify which matches to keep. Basically, any row in column B that does not contain a team name from my 'Team List' wants to be deleted. There is a couple of teams that look like duplicates in my team list but that's because they have been spelt slightly differently in the original data set. Therefore, it is right to keep both spelling of Cleveland Cavaliers in the Team List.

Any help, much appreciated.

Cheers,
Adam.