Excel can do it any number of ways. The hardest part of solving a problem is understanding what the problem is.

Are you saying that anytime you add a new name to either worksheet that you want the program to update the Manager - Employee relationships on Worksheet Roster?

One way to approach that would be to put all the names in a list or array and then search through each name. The input box would be replaced and you would use some sort of loop to cycle through all the code until all the names had been updated.

As far as design, I'd use something that will never change or be duplicated like an employee ID and Manager ID. First and Last names will help but what if a person gets married and their last name changes or you hire two people with the same first and last name?