A folder contains 1200 worksheets named based on Ac/ nos. of my clients.
Another main sheet linking them looks like this.

AC NO NAME CODE BALANCE
31648 A B RAMI 18424100 188.85
31734 A K DESAI 249 61.50
31777 A M SHAH 13527 230.15

Numbers in coloumn A are manual entries.
Name in B has this reference as of now. (
='F:\CONFERENCE\[31648.xls]Sheet1'!$A$1 )

Code in C has this reference. ( ='F:\CONFERENCE\[31648.xls]Sheet1'!$B$1 )

And so on..

I tried this : ="'F:\CONFERENCE\["&A1&".xls]Sheet1'!" which gives me
'F:\CONFERENCE\[31648.xls]Sheet1'! in the cell, when i enter 31648 in A1. But
corresponding value is not displayed.
Since there are 1200 files its very difficult to manually type references
for all of them.
TIA.