Auto-updating other sheets with new row

[meileetan]

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.

[Pecoflyer]

Hi,
if you try Googling around you will find lots of answers.

[gebobs]

Is it a 1:1?

i.e. if project xyz is on row 12 of the Master, is it also on the same row and only the same row on the other sheets? Is the project ID always in column A?

If that's the case, you can just select all the tabs, insert the row, and type in the project ID.