linking in excel

[OssOss]

Hya for all i have a bit fifficult question thus its possible to create a dinamically changing link in excel i mean i have a buch of excel files and i need to extract exact data from them to an another excel file and im too lazy to create a separate long command lines for all of them i wanna to make an one command line and dinamically replace the file name in that command which ones are indicated in the adjacent columm in the output sheet.


all files are named lkie this :1.slxs, 2.xlsx.... up to thousands...

i thinking about a solutions something like this:
='C:\Users\Oss\Downloads\[(number of the file).xlsx]Sheet1'!$A$1

is there possible to do a stuff like that?

who solve it for me i owe him a beer :-)