By Gaspar Desnoyers at July 02 2019 07:21:52
Using the Consolidation feature. You can determine whether or not the link will be interactive when creating the consolidation. This method provides the greatest level of detail in the summary worksheet. You can choose between any function, not just the sum function. For example, you could create an average of several divisions in a summary worksheet. Some of the disadvantages of this method are that the worksheets must be identical. Although it is not impossible, it is difficult to use consolidation across workbooks.
The answer, of course, is YES they can. In my perfect world of mathematics education, no pre_school child is ever exposed to a worksheet of any kind. I would swing my magic wand, all worksheets would disappear, and the memory of them would be gone forever. In the real world, I know that simply won't happen. There will still be some parents who will insist on using worksheets.