if I understand correctly, you are attempted to build and
evolve models  after which you wish to generate a report  with a neat
layout.

Given that this is the problem, I may have something interesting to
share with you. I am currently consulting with a company that has
given these issues some thought. They are building a product called
ModelSheet that separates model  logic from sheet layout, while using
web workbooks (similar to Excel workbooks) to visualize the model
during the authoring process. It captures model logic with named
variables that have dimensions, time series and data types. Formulas
are expressed with named variables; they apply to regions of cells, so
there are far fewer formulas. Cell addresses don't exist anywhere. You
can build and evolve your model in ModelSheet, and then export it to
Excel where formulas are expressed with cell addresses. You can also
re-import any values you change in the generated Excel workbook to
update and refine your original model.

You can learn more about the product at http://www.modelsheetsoft.com
If it interests you, they are currently organizing a beta test, and
are looking for participants.