By Amy Ostendorf at April 20 2019 17:55:52
Using Paste Link. This also creates an inter_active link. The linked cells do not need to be in the same location on all worksheets. You can link between worksheets or workbooks. This is a great way to link totals from one worksheet to another, however, you do not have the detail that is provided by Consolidation.
So the next time you do a search for curriculum materials, skip the worksheets. Instead, consider resources that provide interactive experiences or consider sites that provide students with challenging problems. These sites will more likely engage students, foster discussion, and build a true understanding of the purpose and joy of learning math.