Pull info using multiple criteria (if a1=x AND b1=y then z)

[Jazz Jones]

I have a rather large master spreadsheet containing vacancy information for a number of teams. We've been asked to provide regular drill-owns into the number of vacancies/time open/status updates etc.

Is there a way that I can create a new tab for each team that auto-updates linked to the master so that I can snapshot only necessary info?

Eg. If A1 = Team A and B1 = Active Vacancy, then copy cells x,y,z from row 1 into the new sheet.

Happy to work through column by column in the new sheet to make sure only necessary cells are used, but can't figure out how to set the criteria.

Thanks

 

[Jazz Jones]

I've tried running a macro (but I'm a total n00b) and an advanced filter but I still can't figure this. It's driving me nuts!

Any suggestions gratefully received...