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.

Here are reasons why math worksheets don't work if you want students to understand math, enjoy math, and think mathematically. Math worksheets are not engaging. Numerous research studies have found that when students are actively engaged with the content, they have a much better chance of understanding and remembering what they have learned. Unfortunately, math worksheets tend to bore most students, especially those who need the most help in math.