locating info in a closed workbook

Hi,
I have just started a company and they have a master workbook which contains details of specific jobs. The job file numbers are listed in column A (5650 to 5699 in this example)
I can get the info out of excel by typing this formula
='F:\Costings\5650-5699\[5690.xls]Invoices'!$D$45
The 5690 is the job number (5650-5699 is the folder the excel workbook is kept in)
Is there anyway I can get excel to change the [5690.xls] by using the numbers in column A? instead of having to manually change each line to correspond with the job file?
Hope this is clear.
Thanks
Lisa

Hi and welcome to the board
try
="'F:\Costings\5650-5699\["&(a1)&".xls]Invoices'!$D$45"
(supposing job file numbers start in A1)
and pull down a needed

Hi,
Did that work for you? when I do it - it returns #REF
I really am at a loss on this one, but will save me so much time as I have 50 folders, each containing 50 files that I don't want to have to individually reference!
Thanks
Lisa

=indirect("'F:\Costings\5650-5699\["&(a1)&".xls]Invoices'!$D$45")
Sorry, my mistake

Hi, I must be doing something really wrong, but it still comes up with #REF - I even pasted your formula direct into the sheet just in case, but still nothing!
What am I doing wrong!

I wonder if the problem lies with as soon as you put [xxxx] excel will only recognise that as the workbook name, so if I put in A1 it only reads A1 and not the content of the cell... there must be some way to get round this. I am in excel hell at present!