You can always copy data from one worksheet to another, but if the original value were to change, that change would not be reflected in the cell range to which you copied the data.Rather than remembering which cells you need to update when a value changes, you can create a link to the original cell.By Greg Harvey Excel 2016 allows you to consolidate data from different worksheets into a single worksheet.
If you used a template to create each worksheet you’re consolidating, or an identical layout, Excel can quickly consolidate the values by virtue of their common position in their respective worksheets.
That way, Excel will update the value for you whenever you open the workbook.
If multiple worksheets hold related values, you can use links to summarize those values in a single worksheet.
However, even when the data entries are laid out differently in each spreadsheet, Excel can still consolidate them provided that you’ve used the same labels to describe the data entries in their respective worksheets.
Most of the time, you want to total the data that you’re consolidating from the various worksheets.