Automating a task between two files

I have two Excel files. On one, there is a long list of baseball player names. On the other, there are also baseball player names, but there are stats next to the respective names. The goal is to take the information from the second file, and put it next to the names in the first file. So far, I have been searching the name on the second file, and copying the stats to the other file next to the respective name.

How can I automate this tedious and long process?

I have a background in programming with C++, C#, Java, etc. I could probably write this in C# if I really tried, but I have a feeling that's not the best approach, or is it? (I'd have to look up on how to handle Excel files)

Hi q's,

Please take a moment to read the forum rules and then edit your thread title to something descriptive of your problem. "Automation" describes what any macro is used for, not a specific problem.

Thanks.