Reorganising data into another worksheet format

Hi All,

I hope someone will be able to help me with this.

I have a workbook of a number of pages including a page for every project I'm working on - the client, tasks, date due and task owner details.

Also in the same workbook there is a sheet for each one of my colleagues and I need to be able to pull the relevant information out of the project page into that sheet for each colleague so that they can always see what tasks they need to be working on. I don't know if that makes sense but I have attached a sample sheet for reference.

Looking forward to your responses!