Link a part of external source to a cell

[NilsYan]

Hello,

I have several excel files with the same structure, and these files' names being country names (Portugal, Spain, Greece, etc.). In a separate file (File Output) I would like to return the Cell F4 from Sheet 1 of all these files into column B. In File Output, I have the names of countries in column A, and I would like to link the formulas of column B to column A cells and drag down. For example, Cell B4 = Desktop\[April2019 Portugal.xlsx]Sheet1'!$F$4. Instead of "Portugal" I would like to have "cell A4", so that it reads Cell B4 = Desktop\[April2019 "Cell A4".xlsx]Sheet1'!$F$4

Thanks