If you're just trying to amalgamate information from different sources, then I agree that you're faced with some manual work such as using the Matched concept provided.
If your intent is to keep this table structure, then you're on the wrong track. Names should not be used as primary key values, should not be duplicated in other tables and should be split as first and last names. The primary name table should use an autonumber id as the pk, and the pk values should be in other tables instead of the names. Alternatively, employee numbers that are never deleted, never edited and never duplicated make good pk values in lieu of autonumbers.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.