& in file reference in excel formula

Hi all!

i use the function =INDEX('F:\ANALIS\FIXD_INC\DAILY\new\SYSTEM\EXTER_DEBT\[CIS_BONDS_120716.xls]Sheet1'!$B$3:$I$263,MATCH(B3,'F:\ANALIS\FIXD_INC\DAILY\new\SYSTEM\EXTER_DEBT\[CIS_BONDS_120716.xls]Sheet1'!$B$3:$B$262,0),7)

the part of the file name in bold is the date. There are pull of files, names of wich differ only by this date-part. I wanna play with these dates in the files names with & operator. For example, i in the col A i put 100 rows of different dates and then drag the above formula, while all formulas refer to different files according to the date in the col A.

Is it possible? pretty sure it is, but how??

Thanks in advance!!

Thanks for replying!!

=INDEX('F:\ANALIS\FIXD_INC\DAILY\new\SYSTEM\EXTER_DEBT\[indirect("CIS_BONDS_"&text(today(),"YYMMDD")&".xls"]Sheet1'!$B$3:$I$263,MATCH(...

This doesn't work #REF! error

Thanks you all! i guess it's indeed the best option available.