In order to prevent excessive entries of the same information my company
wants to link a master account list to the individual lists that we currently
updated for the purposes of using the master spreadsheet in Access for
reporting of information. For example:

Spreadsheets X234, X235 and X236 are all individual sheets; X234 contains 25
accounts, X235 contains 500 accounts and X236 contains 67 accounts. The
master spreadsheet contains all 592 accounts. We receive a notice on client
#56 on spreadsheet X235. Instead of updating the information twice (on the
individual and the master) we enter it on the individual only, but it updates
automatically on the master. The director doesn't want to use only the
master sheet because it will not include ALL the aspects that the individual
spreadsheets contain.

Is this possible?? Even if it is a lengthy process we would like to do this
(it's a temporary fix until our database is completed, but that won't be for
another few months).