Where field = X, populate new tab with fields from column Y

[delladean88]

Hi All,

I am a complete novice when it comes to Excel, so I apologise in advance if the below question is incredibly straightforward -

I have taken over a team of Project Managers, and there is currently nothing available to show me easily which particular tasks they are working on.
There is a larger spreadsheet that details the tasks (along with other a large amount of other data) and the PM assigned to it.

I would like to create a new tab on this spreadsheet that would list the Project Managers as a column header, and list the tasks they are currently working on, per the master spreadsheet - so that if they have to be realigned, I wouldn't need to maintain this list manually (there are actually 18 PMs and over 150 different tasks).

Is there a way I can pull the information from one tab to another, where I can have the Project Manager as a column header, and the tasks assigned as a list underneath? I have attached a mock-up on how I'd want this to look in the second tab. I need to be able to see the information easily for the whole team.

Many thanks in advance for your help!