Is there a way to create a master list of names in one sheet so that when you add or delete rows or columns in the masterlist the other sheets that use this masterlist will automatically add or delete the changes?

How would I copy this list. I tried to link it as a formula but that didn't work. I would like to link up to 30 sheets on one spreadsheet and have the names change with the changes made to the masterlist.

Thanks,

Tschabby

Try using pivot tables