Excel tables

I have a spreadsheet that tracks the time that myself and colleagues are spending on each project. Each person has a sheet where they enter their projected time, and actual time per project at the end of each month. Each project has a sheet that pulls in data from the people sheets in order to work out how much time we have spent on a project.

We are having to add more and more projects and people to the spreadsheet, which becomes a very time intensive process to update. Every time a new person is added, they have to be added to each project spreadsheet individually. Similarly when a new project is added, I have to update all of the people spreadsheets individually.

Is there any way I can create a master table that would update the rows of all the other tables without interfering with the data inside each of the progeny tables?