Matching names from sheet2, sheet3, sheet4 with names in sheet1

[Lynx2x]

Hello again!

Yesterday guys hellped me out with some problem and now as I move on I got another one, that is connected with the one before, but diferent, so I'm posting new thread.

I have a workbook (attached at the bottom of post), where in column A there are Data (mixed names and surnames), in column B and C there are cleaned and separated names and surnames, but we still don't know what is what. So in sheet3, 4 and 5 (MaleNames, FemaleNames, Surnames) we have databases of names(M/F) and surnames and my question is if it is possible to lookup every cell from column B and:
1. compare with male names (sheet3) and if there is a match we copy that name in D (Name Male B)
2. compare with female names (sheet4) and if there is a match we copy that name in F (Name Female B)
3. compare with surnames (sheet5) and if there is a match we copy that name in H (Surname B)

Same lookup and compare we then do for column C only that we copy names in columns E, G, I (Name, Male,Female, Surname C).

Can please someone can help me with that?

Thank you guys, you are the best

Tilen

Example22.xlsx