Without any more information than that, one can only offer very general suggestions.
Excel has long had a function called VLOOKUP which can look in a table for a match to some ID--such as name--and then retrieve adjacent columns of data. VLOOKUP is one of the most commonly used of all the functions.
There are newer and more powerful variations on that tried and true standard.
If you need further help, though, ay I suggest you come back with a sample of your actual data, just removing real names and any confidential information. Create a mockup of the way your data are arrayed.