By Benjamin Guedry at June 06 2019 15:15:11
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.
Microsoft Excel includes a number of little known shortcuts, tips, and tricks to quickly manage the worksheets in a workbook. These hidden tricks can be big timesavers as you move between worksheets, and add, rename, and copy Excel worksheets.