Adding Rows to one sheet when Data is added to the first one

Hey Guys,

Any help you can provide on this would be fantastic.

We have a document where we record the training that people have received, where the tabs list different types of training. The list of names is the same on all of them.

All I'm trying to do is set it up so that, if I add a new name on page 1, the data on the subsequent tabs will be updated (so the name will be added) and the related data moved down, so it doesn't all go out of order when a new name is added. Other than the names, none of the data is linked.

I can think of a couple of ways this might be done but they're a bit over my head.

The simplest solution would be to create a master sheet (of all the data) and then populate the sub-tabs based on the master sheet. However, this document will be being maintained by multiple people and they will almost certainly screw it up that way.

I can set it up so that there is a Frozen side panel of names that links to a master tab (of just names), I just don't know how to set it up so that, should a new name be added, the information automatically moves down.

Any help you can provide on this would be greatly appreciated. Even if you can just point me in the right direction for how to set such a thing up I would greatly appreciate it.

Regards,

Ben