Reference a workbook with only a partial name
 

Hi all, just a quick question,
I have multiple workbooks each labelled using the format:
€œInvoice number €“ clients name€�
Is it possible from a master workbook to refer to a work book if I only know
the invoice number?
So if I enter invoice number 9484 into the master workbook it will look up a
cell reference from workbook €œ9484 €“ Company Name€� ?

Please help!! Chris