Guide

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.