Hello, I am The-PC-Guy. I will do my best to try and help you.
what exactly is it you are trying to accomplish What are you trying to copy, from where to where?
there in lies the problem with combining different data sets.
Is there any common field between the 2 sets, anything at all?
I can certain help you with importing from multiple sheets to a single master sheet. But if you want to combine the data there needs to be at least 1 common field between the 2 sets of data.
As for the analysis, that is not my area of experties, I know there are a bunch of plugins for excel that can do various statistical analysis and forcasting, simulations and scenarios. I can reccomend a few, but as far as how to use them would be up to you to figure out.
if you could send some example excel files that might help.
well I certainly can create a macro that could combine the 2 sets given that they both have dates and times, it is just a matter of merging the info in that circumstance.
Also you said multiple sheets, does this mean they are in multiple workbooks?
assuming that all the sheets are in exactly the same format and I mean exactly, it shouldn't be a problem to automate it. I don't think I would make it look exactly like your master, I have a different idea in mind that should make it easier.
Now for the cost.
This is a very complex issue and will cost at least $300. This is just for the population of a master sheet, obviously anything additional would add to the cost.
I'm sending an addtional service offer, if you accept it I can get started.