Search one list for any substring matches from a second list of words

I have a list of data in one column (call it column A) that includes football transfers from 2015 e.g. "Jayden Stockley (AFC;Bournemouth - Portsmouth)". These have players names in them but also their respective team before and after transfer within each cell.

I have a second list of data (call it column B) of several hundred football players, with no teams, just their names e.g. "Jayden Stockley", "Rob Jones", "Peter Drury".

I would like to find any transfer that in is column A that includes any of the names from column B (not an exact match because column B will not have the teams or brackets, just the name).

If I were doing it manually I would highlight column A and hit ctrl + F and type in each players name from column B one by one and then see if they made a transfer, but there must be a way of the search looping through list B without me typing them one by one.

Ultimately I want a copied list that includes only transfers from column A that is of players in column B so I don't know if its easiest to find matches and then manually copy and paste into a new area of the spreadsheet or if a formula could copy the cell if it is a transfer that is of a player from column B.

Thanks in advance for help, apologies I couldn't find out how to do this from other posts.

That is fantastic thank you FDibbins,

what will happen using these formulas if there are multiple occurrances of a player in list A? The index stuff has worked brilliantly and tells me which column to copy the data from, but it the same player has two or more transfers will I know using this formula?

Thanks again

Hi,

Attached is the first section of the data I am sifting through.

Thanks,
thprest02