Master Contact List for use across sheets in a workspace
I have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into each of the 16 grids and make the same change. Is there a way to create a contact master list, or group (similar to an email distribution list) that I could reference and it would populate a Contact List. And as people joined or left, all I would have to do is update the master list to add or remove the contact, and all 16 grids would update?