Hello,
A little insight to the situation. We have a template workbook that we use
each time to start each new quote estimation. There are some clients that
order from us often and need specific standards set up just for them. there
are about 20-30 different "standards" that they have.
About once every 3 weeks, the template that we use (which I guess is kind
of a Master workbook already) is updated with new prices for different
materials. For instance, the cost of hot rolled steel might fluctuate in
price along with the cost of labor or something. Once these prices are
updated in the "master", we just do a Save as, find the appropriate folder
for the next estimator (only 3 guys at this poing) and save it as their new
template. The problem comes in with the special 20-30 "standards" for the one
client.
I would like to find out if it is possible to somehow link all of the other
templates to one master work book so that all of the updates can be done in
one fell swoop. This would save us time because then we wouldn't need to
manually go to each and every file, update the 10-12 changes in each file,
then do a save-as for each one. Is this possible or am I asking too much?
Also, with this situation, would anybody suggest moving to Access to contain
the data and just creating estimating invoices?

Please let me know if you need further clarification. I'm sorry that I can't
really generalize this to make it simply data oriented. A lot of times, I see
that too little is known about the situation and when the answers are
provided, there are a lot more questions.

Thank you
Syberpanther