Have you tried using Sets to combine your fields? Can you attach a workbook?
As i was gathering data to post a workbook, I had a thought. Its easier to keep every calc in a separate sheet and simply combine them with a dashboard. No need to reinvent the wheel, simple solutions are the best