We have a spreadsheet where we have a list of tasks that we assign to several people.
e.g.
Task 1 Jim
Task 2 Pete
Task 3 Jim
Task 4 Donna
Task 5 Jim
We want to create a worksheet for each individual, that will automatically get populated via linking to the main worksheet.
So for example, Jims worksheet will list Task 1 3 and 5 on separate lines. Donna and Pete will also have their own list.

Does anyone know how to set this up so it will work seamlessly?? Is there a clever way of using IF?