Building a reporting tool

Hi Guys,

This is my first time on this forum but it won't be my last. I am pretty functional with excel but lack VBA/macro skills but I am in the process of improving these skills.

I am a currently on an internship with a large company and they want me to automate one of their current processes as it is currently inefficient.

Currently the Key Account Managers at our business inputs new updated prices of all their sku's for each retailer and then sends the file to my manager and then they read the updated prices off the sheet that was sent to them and lastly they input the changes onto a different excel document.

I want to make this process very simple and efficient. It is one of my projects for the term so I want to do very well. Who know's they might like me and hire me full time after.

Any ideas and help would be greatly appreciated.

Thanks!

Mike