Write MS Excel Macro / Pivot Table and create a readable layout for monthly performance tracker

We have monthly data reports which come in the form of 3 excel spreadsheets. We'd like to combine the spreadsheets into one overall report which is presented in an easily readable format. This involves pulling certain data cells from each sheet and combining into the 'master' sheet (by product and by product type). Different products types require different sets of the data.

It is fairly easy to do this manually but is quite laborious. We were thinking that a simple macro could probably handle copying and pasting of the relevant data but I imagine that those with good Excel expertise could probably come up with an even more effective way of doing this.

At the moment this is just a short project rather than on-going work. However, we are always looking for good people to join our team so, if successful, there is the possibility of the project leading to regular work.

If you're interest please reply with a short message as to what your specific expertise is in this area and roughly how you would go about the task.

Thanks for your interest.