Create a master sheet that updates subsequent sheets (like creating or deleting columns)

I would like a master sheet will all the names that will add or remove columns when new names are added/deleted. The arrow represents the end result of what the other sheet would look like after the master sheet removed "Randy".