Linking 1 cell with others next to it

[number novice]

We have a program that outputs as per the attachment. The list of people is 500 names. I need to be able to using a list of 60 names extract each name and the information beside it. I am doing this manually at the moment however it just be comes tedious when a change is made and I have to go through it again. I thought of doing it with macros but some of the names have no information beside them and they are not evenly spaced in places, Also, when another person it inserted in the list, the macro loses the reference points. I have tried to use OFFSET but can't seem to get my head around it and LOOKUP and MATCH had me totally defeated. Is there a way of using IF to search for a name then have something else gather the information that pertains to that name. Hope I have made this easy to understand?