Matching up data from multiple documents
 

I need to match up data from multiple documents and put together a list from
those that match. For instance, I order parts from several companies-and
have lists of those-I may order the same part from several different
companies, and each company may have a different specific part number, but
they have to all contain the manufacture number in it. Is there any way that
I can have the ability to put a part number in and get a list of matches from
my various spreadsheets?