Multiple worksheets data - delete unwanted data - consolidate da

Hi all,

I'm in another complicated excel scenario.

I have an existing worksheet (180 rows approx), with some data (client, job position, job id) but am looking to add:
- skills
- recruiter name
- candidate name

I was able to extract a much longer and detailed list on a new worksheet (800 rows approx), with all the data I needed (mentioned above). The problem is that I now have an excess of entries as you can notice by the nb of rows.

I tried using the INDEX/Match function to fill my original worksheet of 180 rows, but the values returned were wrong because the 'job id' (which is the only reference I can use to find the other needed data), was used multiple times in the new worksheet of 800 rows.

I would like to take a step back and:
- delete from the new worksheet all the rows that I don't need, keeping ONLY the ones I had in my original worksheet (180 rows).

Can you please help me with that?

If I manage to do this, then my index/match formula would work well, but now it's all a mess.

If you have a better and smarter suggestion, I'm all ears.

Thanks,
G