creating automatic hyperlinks
 

I have made a spreadsheet where i need to hyper link to other workbooks
spanning into the hundreds of other sheets.
I have a customer number in column B then i have information etc and in
column N i have a hyper link to a seperate file. The name of the file
is the same as the customer number. Is there any way i can get excell
to as soon a a new customer number is enterd it will automaticly create
a hyperlink to its file in row N