Link data from excel files: how to change the position of a cell in file1 so that the data from this cell is still transferred to file2?

Question

Macros

There are two excel files: file1 and file2
From certain cells of file1, data is pulled to file2.
But due to the fact that rows or columns can be added to file1, the cell in it from which data is pulled to file2 can be shifted in the table.
Question: how, when changing the position of a cell in file1, to make sure that the data from this cell is still transferred to file2?