Matching/Counting items
 

I have a spreadsheet with several worksheets with in it. The first worksheet
which it my master sheet contains about 4000 part numbers. Each part number
is housed in individual worksheet for catorgory reasons. How can I find out
that every part number in my mastersheet appears in its individual catorgory
sheet without doing a long winded way of Find on each item.