Excel 2007 : Nested Search Or I do not know what to call it !!

Hi All,
I am new in this forum, thanks for your answers in advance.

I am having an issue which I don't know how to solve it.

In my attched file I have two cloumns, the left always start with 416 number, the right number has 216 numbers and 416 numbers.
when you filter the left coloumn to show 41600081 it should show some 216 numbers and 416 numbers, you will get somthing like below

Material Component
41600081 21632826 <-------- Copy this into the same sheet (Sheet 216)
41600081 21633499 <-------- Copy this into the same sheet (Sheet 216)
41600081 41603275 <-------- do anather filter or search to look for 216 numers that related to this number

What I want is to copy 216 numbers into new sheet (Sheet 216) AND search for 216 numbers that related to 416 numbers in Component side

Material Component
41600081 21632826
41600081 21633499
41600081 41603275
41603275 216XXXX <-------- Copy this into the same sheet (Sheet 216)


I need to do that untill I found all 216 numbers.

Is that possible? I hope my English is clear to you, maybe not

Please if you know how to do it, I need your help....


Thanks so much again