I have a folder in my HDD. The folder name is DC.
this DC folder contains lots (more than 100 files) of xls files. The names of the files are 1dc.xls, 2dc.xls, 3dc.xls.....155dc.xls etc.
Inside of those files there are some data, but I need to work with data in cell only from A2 till N2.

From the other side I have master xls file, called DC Master.xls. In the first column A I enter the name of the hundrets of my files, like column name is "File Name from folder DC" and it will be 1dc.xls, 2dc.xls etc.
But in in master file in second column B I want data from the second column of *dc.xls file.
Let's say in master file in column A3 I enter "3dc.xls" and in master file in column B3 I want the data from file 3dc.xls from it's column A2. The thing is I don't even want to open file 3dc.xls and just put simple reference to it's cell A2. What I want to copy all other/future files 156dc.xls to my folder DC and put in my master fild DC Master.xls in the first column "156.xls" and the data from 156dc.xls file appeared in column from left.

My idea was in master file Master.xls in the second column B get the data from the file which name in the same row but from the left.

Imagine this is Excel cells and I want to see this:

A B
1 |File name|First data from file|
2 |156dc.xls |Alex G |


But in formula I did as follows:


A B
1 |File name|First data from file|
2 |156dc.xls |='C:\Users\Eugene\Desktop\DC\['&'156dc.xls'&]Sheet1'!$A$2|


But it didn't work.
Using combining of the cells value ( I always know that the dc files will be stored in one folder and the name of the files will be very similar) I was able to generate correct URL adddress of the file but as text form not as as link.

My question is - how may I convert text value of the cell to LINK?

Ouch...guess I was specific enough...
Thanks fellows!