We have several mailing lists, that do not share the same people. What I would like to accomplish is have a master spreadsheet where once we enter a persons name/info it updates automatically on which ever mailing list they are on. The only solution I know to implement would be the IMPORTRANGE function. However if I were to add or remove cells this would cause more trouble than it;s worth and we have over 400 contacts. Any way to attach a formula to a name(Ie Edward Smith) then have the rest of the row copy info from the master sheet? Sorry I am novice at this