By Hamid Bloem at May 08 2019 08:07:30
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.
Budgeting Worksheet Tip #1: Find a Budgeting Worksheet with all the Categories You Need