data from another excel table based on cell values

[depedro11]

I have a table:

A2: 2021_010
A3: 2021_011
A4: 2021_012
and so on

in each line I would like to get data from another excel with the following:
for B2:
'D:\folder\2021_010\[2021_010_A- A.xlsx]Sheet1'!$G$10

for B3:
'D:\folder\2021_010\[2021_011_A- A.xlsx]Sheet1'!$G$10

for B4:
'D:\folder\2021_010\[2021_012_A- A.xlsx]Sheet1'!$G$10

Thanks

 

[depedro11]

Sorry, I wrote wrong.

My correct question:

I have a table:

A2: 2021_010
A3: 2021_011
A4: 2021_012
and so on

in each line I would like to get data from another excel with the following:
for B2:
'D:\folder\2021\2021_010\[2021_010_A- A.xlsx]Sheet1'!$G$10

for B3:
'D:\folder\2021\2021_011\[2021_011_A- A.xlsx]Sheet1'!$G$10

for B4:
'D:\folder\2021\2021_012\[2021_012_A- A.xlsx]Sheet1'!$G$10

There are hundreds of data in column A, so I would like to create an automatic function to column B.

Thanks

 

[depedro11]

I have this function but if I copy this to another cell, it will be the same:
='D:\folder\2021\2021_012\[2021_012_A- A.xlsx]Sheet1'!$G$10

If I write this, it will not work:
='D:\folder\2021\&A2&\[&A2&_A- A.xlsx]Sheet1'!$G$10

How can write a function to work in all cells?