Any Excel gurus in the house?

[MANative]

Howdy! I'm a fairly competent user but I've got a task that's driving me nuts! I've got two spreadsheets from different sources with the common link being an employee name. The data from the two spreadsheets needs to be merged into a new spreadsheet which will take some data from both sources but not all of it. I'm trying to figure out the most efficient way to do this. I'm thinking maybe VLOOKUP or IFSUMS could be the way to go, but I keep making a mess of it. Any thoughts on what strategy would be best to accomplish this? I'm happy to do the YouTube searches for step by step instructions, but I'm hoping that someone has an idea which approach might be least cumbersome.

thanks for any advice you can offer!