If anyone can help me with this one, it would be greatly appreciated.

I'm trying to create a central spreadsheet that can be accessed by all users
on our network for client address & shipping details etc
I have a central sheet with customer code(4 digit code) in A1 and address
details in B1.
When creating hundreds of seperate spreadsheets there is a cell where you
can enter this 4 digit code (e.g F10)
When this code is entered into F10, another field (F11) must read the
details of field B1.
Is this possible?