How to add or remove names within one sheet and automatically update others

Hi,

I have created (with a lot of help) a tracking and monitoring spreadsheet for school.

I have a sheet within it titled 'Add or Remove Names' that the other sheets pull information from.

How can the spreadsheet be set up so that if I delete a row within this then it will automatically delete the information within the other sheets to do with that particular child.
Similarly if I was to add a child to this sheet it would automatically update the other sheets with the child info also?

It may already be able to do this- I am afraid to try out incase I break it!!

Any thoughts or ideas?

Thanks,
Kevin