formula linking information from another spreadsheet with another imbeded

[j_thain]

Hi there i am having problems finding a fomula for my spreadsheet. i use it to keep track of ivoices i make. each invoice i make is saved as a seperate file.

ive then got another spreadsheet (shown below) to to extract the date, name, and amount from the original invoices.

but

i have to enter the code manually 3 times for each invoice chanceing the name of the file (which is 182.xls on the one below)

but instead of changing the formula name ech time could i use the infomation from colom 'b' as the ref no is also the file name

i thought that this might work but it didnt...
Before
='C:\Documents and Settings\Tom\Desktop\printing invoices\Jobs\[182.xls]Invoice'!$D$45
After
='C:\Documents and Settings\Tom\Desktop\printing invoices\Jobs\[B5]Invoice'!$D$45

please help

click here for a screen shot
\1