I am using msoffice 2003 and winxp pro

We have a master workbook that contains worksheets for all vendors we do
business with, each vendor having it's own worksheet in the workbook.

We have workbooks for each of our customers, each workbook containing a
worksheet for each vendor the customer buys products from.

The master workbook contains the pricing for all products. When prices
change, we are currently making those changes on the customer worksheets
manually. I want to make this automatic by linking the customer
worksheet to the appropriate vendor worksheet in the master workbook so
entering the changes once will reflect in all of the customer workbooks
that contain the worksheet that was changed in the master.

I know how to do simple cell linking between worksheets/workbooks. My
question is if this is the correct way to generate this project when we
are talking about maybe 250 customer workbooks each containing several
worksheets, all being linked to the master workbook containing about 40
vendor worksheets.

My concern is if this is the most efficient way to do the job, if you
can have this much linking going on without ending up with a 'spaghetti'
type mess, or if there is a better way of doing this, perhaps using vba.

Because I hate doing things more than once, I thought I would ask for
advice before proceeding. Any hints and tips, advice you can give me to
get this organized and up and running would surely be appreciated. You
will be giving me your time and saving me innumberable hours of
scrambling around.

Thank you
Joanne