Saving multiple worksheets to a master file
 

Hi Guys,

I have created an excel form that will be used by 5 agents. How can I get
their spreadsheets to automatically update the master file on the €œZ
drive€�? Also How can I create a form to €œsearch€� this master file for the
customers
number. Once it is found to view, pull through into a form, the associated
other fields related to the customerIDnumber.

Can you help?

Albert