Hi-

I have a workbook that contains several different worksheets, and I would like to create a master worksheet that contains all the information from the other worksheets.

The workbook contains all the different mailing lists that my office has, and we update these lists often. Some people are on more than one mailing list. So, sometimes when an address needs to be changed, the editor misses one of the lists and so there are different addresses for one person.

How can I create a master mailing list worksheet that: A) contains information from all the mailing lists, and B) when updated, also updates the identical info on the other lists. So that instead of manually changing a person's address on each list they are on, when the info on the master list is changed, the same info on the other sheets is automatically updated.

I hope this makes sense and that this idea is possible. Any other ideas are welcome, too. Thank you!