Looking up data from one Excel Sheet and putting on another

Hi Everyone,

First of all I would like to apologies firstly if this is in the wrong section however I'm needing some help if possible please.


I have a worksheet and on that has the following cell headings - In The Box Leader Staff System CI QA ATS


What I'm trying to do is write a macro or code to pick up all the people with 1 under the in the box fields and then gather the rest of the data and place it into another worksheet for me.

I hope someone can help me.

thanks