Linking cells together in Excel is very simple. You can reference them in different sheets. The Excel cell can be linked to the cell in the file, which has its own advantages and uses. Now, you learn how to link an Excel cell to a cell in another file.
A simple way to link a cell to a cell in another file
First open both files to use the data of another Excel file. Suppose the name of one is A and the other is B. The goal is to have the C2 cell from file B (just one sheet) equal to the data A4 cell in file A. In file A, select the cell A4 and copy it. It does not matter if you do this with the shortcut Ctrl + C or use the copy button in Excel.
The next step is to select cell C in file B. The last step is to paste, but not normally, use the Advanced Paste button in the right-click menu or the Paste menu in Clipboard box in Home tab. Click on the icon that appears on the link.
Notice that the link created means that the cell from the file A always depends on the file B. If the path of the files is changed, the link disappears. However, you do not need to have both files in a folder.