Auto update master worksheet from multiple worksheets

Hi,

I have created a spreadsheet to track project officers projects. each project officer has his own worksheet displaying only the information that is relevant to him. The master has other information that is used from an administrative point of view.

I want that when a project officer adds a new project on his worksheet it automatically adds to the master worksheet.

Can anybody point me in the right direction on how to do this?

I can add the file if you need it?

Lee