How to create a source sheet that automatically updates other sheets if data is removed?

Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added to all subsequent sheets.

Currently part of our process when adding/removing participants requires us to go to numerous sheets and make sure they are removed so I am hoping to automate that if possible.

Any help is appreciate, thanks so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!