One problem with this is that you are now setting the cell to a value, not
a
formula, so if the underlying values get updated, your summary sheet does
not.

As long as it's accurate, that's all that matters. No data gets input -
they're just reports with graphs. The whole thing could be done in Access,
but the company doesn't allow Access on employee's workstations. So there's
an "operator" that runs Access to generate the worksheets, then they get
emailed around. These folks are still on NT ...