How to update unlinked columns according to content of a column linked to a external source file?

Hello to all of you. Situation: I have created an excel file with about 20 columns, of which the first 4 columns (A to D) are linked (external references) from a source file. When I update the sou...