I have 1 master sheet with a list of projects. On other sheets, I use the same list of projects and add on other columns of data. Can I automatically add a new row (project) to all the sheets by just adding once on the Master Project sheet? I would also sometimes delete rows (projects) from the Master list and need that reflected in the other sheets.

Thanks.