How to Link Cells Between Worksheets in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Click the cell where you want the linked data to appear.
2. Type = in the target cell, then enter the source worksheet name followed by ! and the cell address (e.g., =Sheet2!A1); any changes in the source cell will automatically update the linked cell.
3. Hit Enter, and the data from the source cell will appear in the target cell.