adding a vba search code to a button control

Hi Everyone,

I have a workbook with many sheets and a lot of information. I created an entry tool that allows the person to enter a product number. Now what i would need help on is the following: I would like to first have a match type function which tells the person how many times that part number appears within the workbook (This number would appear in cell B3). Then I would like the person to be able to press the Generate Matches button and have those rows that match the product number appear on Sheet1 in row 6. Is this something that is possible? Any Help would be so much appreciated!

Thank You & Have a nice day!

Vicky


PS i included a little example, but the actual workbook would have over 6 sheets each with 15000 rows and 25 columns.