Linking rows to another worksheet based on contents of a field

Hi,

I wonder if anyone can help me. I have a spreadsheet that is basically used to monitor projects in a company. The first column contains the manager responsibles initials, and the next columns contain the project they are to complete for that month (the column headings being the months).

What I would like to do is to create multiple workbooks, one for each manager, and for theat to link to the master document and display the rows that are applicable to them.

For example, in a pseudocode kind of way, if column A on workbook1 = JW display the entire row.

This would mean the MD can have a sheet with an overall view of what is going on, and each departmental manager can access their own projects.

Is this something that can be done? I know ideally we should be using project management software, and we do, but it is simply an overview of existing projects.

Thanks

Richard.