I'm using Excel 2002 and would like to know if there is a way for me to do the following

I have a workbook with several worksheets. Within each worksheet there are several lists of values used for validating data (i.e. Data/Validation-select List and enter a range within that worksheet for the values to be contained in that list). For example there is a list of VPN connection options for the sales person to select from. These options are stored on the Network worksheet in the workbook. That's fine. However, this is also a list of Network Connection options that the sales person can select from and this list exists in 10 different worksheets. It needs to be accessible in all 10 worksheets

The problem is, of course, that when someone updates one of these lists, he/she must remember to update all of the lists.

I would like to do is have one master list of network connection options and set up ranges in each worksheet so that I can use the options in dropdown lists in several different worksheets. Since this list will be dynamic, the referenceing cells in the other worksheets must be able to dynamically update themselves with the correct options

I hope that this makes sense and I'm sure that it involves formulas. I'm just not sure how to do it

Any help would be greaatly appreciated

Thanks

Joe