Lookup the same part numbers from multiple pages
 

Looking up the same part numbers from multiple pages and listing each one of
them on a separate sheet, in a row, no matter how many part numbers are
returned, then carry on or two of the neighboring cells information with it.
For instance: (I have 60,000 parts to look up and carry to another sheet
times 18 sheets)
p/n used for: tsi:
123 bmw 3:00:02
456 saab 6:00:03

Any help is much appreciated,
Thanks,
Champ