I am trying to set up a worksheet which shows differnt projects for different
departments and different members of my team. It will also show start and end
dates for those particular tasks.

This document will hold all the information for all of the projects.

Is it possible to then automatically sort all the data from a particular
department, or project or team member and have it update live to another
workbook?

Potentially the original document would have around 10 columns of data for
each project to be transferred,

and

the projects for a particular team member or project, would be all mixed up

thanking you in advance for your help

Nadia