I don't suppose you can upgrade to 2010 or maybe 2007..?

Regarding, "All that sounds great"; are the source workbooks,by chance, not available to anyone but you? This will take some the complexities out if you can be assured that they will be closed when you update the "Master".