You're covering a lot of ground there, but you should be able to use sorting and group selection, then cut and paste from your other programs, as well as keyboard shortcuts to save some time. There may even be some addins that will help you to organize the reports...but nothing can save you from data entry. There's definitely a steep learning curve involved...
It may be helpful for you to organize the logic and Hierarchy of the spreadsheet by hand on paper before you attempt to set it up on your system.
Google Excel tips and you'll find a plethora of info online to help you set it up right...(
here's one) (
or two)
I hope this information allows you to resolve this issue. If you need further assistance, please post back with a comment to this thread.
If I've managed to answer your question or solve a problem, please take just a moment to rate this post....thanks!