I'm sure a whole lot of people has a certain amount of data with summatories
below, then some more data with other summatories below and so on ad
infinitum with a final total underneath it all. Most likely, they also have
some kind of percentage or calculation in columns to the right or in between
and so on.

When copy-pasting the new data into an old sheet one must either be
extremely careful to copy-paste just the data leaving untouched the
calculation cells for them to survive, otherwise they'd turn into numbers.
When you have a sizeable spreadsheet, this can become very time consuming.

Ideally, one would like a way to somehow "protect" the calculation cells so
that, when someone copy-pastes a dozen columns over them, only the data gets
pasted while the calculation cells remain unaltered.

If someone knows a way to accomplish this and/or knows of an add-in (even if
at a price) that does the trick, I'd appreciate their letting me know.

TIA