I have a list of names and I'm trying to create a workbook that tracks different data pertaining to the list of names in different worksheets. I'm hoping to make one worksheet the "master list" that contains the column of names. Each additional worksheet will also have this column of names but different columns following it tracking different information.

I want to create a macro button that will update the first column in each worksheet if I randomly add or delete a new name in the "master list" worksheet so that all of the other worksheets will insert/delete this row. So if I insert a new name, the row will have the name and everything else blank to fill in later. Or if I delete the name, the entire row will be deleted as well.

Is this possible? Here's an example file... Test_MasterList.xlsx