How to transfer specific product content from one row of a Worksheet to another

I'm comfortable with the basics of Excel 2010 and just learning how to push it to the next level. So here is my question.

I have a list of Contracts each one identified by a specific product. I list them in a master sheet and have a row of various information that goes along with it from contract date to payment information. I continually update that master sheet with up to 40 different products, entering each new contract below the last one. At this point I'm trying to figure out how to use the Master sheet and copy all the information specifically from 1 product to a tab on another Worksheet. So I need a function that searches the rows for specific products and then if that row has the product it pulls all the information onto a designated worksheet.

I've attempted Pivot tables (which I found out was numeric only after a couple hours of messing around), IF/AND/OR Functions but can't find a way to grab all the information from an entire row if it is related to a specific product.

Let me know if you need more info.

Thanks in advance!

Here is a sample of the master sheet I'm using. The columns titles will be exactly the same when I create a new workbook by Title.

The idea is that I can sort all the information for "ANFDT" for example so that I don't have the other "Titles" to deal with. I often have to send reports with only one Title so can't have the others views which is why I'd need to move the data to a different Worksheet.

Cheers.

Thanks for the reply Fotis...I appreciate the suggestion and you're correct in that it does help isolate each Title. My problem is that I do need the data on a separate worksheet because I have many other reports I run from that data.

Initially I thought what I was trying to accomplish was going to be straight forward given how many incredible things Excel can do. But I'm starting to think it's not going to work out how I was imagining.

Cheers.

In about 80% of the cases they are unique but when the Contract Number isn't created in house I lose control over the number. I could just assign an arbitrary placement number in those situations. At this point the contract number works as such. XX-YYY-ZZZ where the XX will represent the year, the YYY will represent the Title and the ZZZ will represent the contract number in that sequence. So 11-003-007 is a contract created in 2011 for the title "Beware" and was the 7th contract we did for that specific title.

So in this situation I'd need to sort by the YYY value.

It would be great if something can come of it using the contract number!

Cheers.