Copy certain data to different tabs depending on values with lookups

[mario0102]

Hi
I have an excel sheet (attached) that has data on a couple of tabs (employees and skills) and I am using a lookup to merge the data together and produce a final sheet (keyholders, fire marshalls, etc). What I would like is to only have certain information looked up depending on the value of particular cells on another tab.

In the attached "employee" and "skills" contain my data. The "keyholders" tab has a lookup to merge the fields that I need. I would like the list to only show lines that have a certain value in the B column on the "skills" tab. The idea being that I will have lots of extra tabs splitting out my staff with different skills.

Hope that makes sense.

Is this possible?

Thanks you in advance for any help.

Mario