I have half a dozen workbooks that are updated each week- one for each group of employees.

I would like to pull some information from them into one summary worksheet so I can see certain numbers easily without switching back and forth between 6 files, and especially to compare employees across groups.

I set up the employees names to pull from the respective workbooks. I'm having trouble with the other columns that need to lookup the employee and return other information (ie Team, Averages, etc). I want to make sure they update and populate information based on the employee's name, not what row they were originally listed on, because employees come and go and people will move up and down the list, so I know not to use "=___(cell)". I was trying to use a V lookup but I keep getting an error message. Maybe beccause the source workbooks employees' names are not in alphabetical order? Is there another way to do this?

I am attaching a sample (Tech Hrs) of what the 6 workbooks look like. I would be pulling from the Summary worksheet. The Comprehensive Tech Hrs would be the worksheet that pulls everything into one place.

Thanks in advance!!