The contents of two cells in excel are synchronized.

By pasting the link, you can synchronize the contents in the cell.

The steps are as follows:

1. copy the data to be linked-right click-copy (ctrl+c);

2. Switch the table to the position where it needs to be pasted, and right-click the Paste Special-Paste link;

3. Modify some data in the data source and test it.