Need to create a Master worksheet

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!!