I've two excel worksheets.

worsheetA has names of people and their father's name.
Name Father's Name
A AsDad
B BsDad
C CsDad
D DsDad
E EsDad


I've taken some of the names from worksheetA into worksheetB (manual
selection)
WorksheetB
Name Father's Name
B
D

How can I populate the father's name column in worksheetB using the
info from worksheetA?