Need to create a Master worksheet

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!

Can you mock up small file to illustrate what you require.

example.jpg example.png

I tried to attach a screenshot, hope it works...

Sorry but it is not possible to work with an image - a file is needed.

Click "Go advanced" then click on Paper Clip icon to Upload file.

See the attached.

In "Farmers" there are 3 ways of updating from MASTER columns D to K. Without using VBA it is not possible to go from either "Businesses" or "Farmers" to MASTER.

In MASTER there is no way to distinguish whether an entry goes to "Businesses" or "Farmers" (or both?): I presume this is required.

It will also require VBA to allow automatic addition of NEW personnel to MASTERS to be added to "Businesses" and/or "Farmers".

Do you also need allow for deletions?

It is never quite straightforward!

Thank you very much for your help!!

If you need further help then please add to the thread.