By Cameron Dyett at May 14 2019 23:30:27
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.
I have said "Don't Use Worksheets" about every way there is to say it, and each time I have included solid brain_based, researched reasons for this statement; and yet, I know that many people will ignore the science in favor of the convenience. It is very difficult to fight the tide when there are so many internet sites pushing worksheets at parents, and so many reputable textbook companies doing likewise. It is difficult to remember the reasons to avoid them when one has very little time to devote to working with math. Worksheets just seem so much easier than doing things any other way. Can they really cause harm?