Extract data from one workbook to another

Hello,
I m a new Vb programmer . I need to write macro for extracting data from one Workbook to another (new workbook) based on some criteria.
Overview of the data in my excel sheet :
Username , Ticket number .....(there is a list of all users and the issues they are working on (unique numbers) .
I want to extract the collective information .Suppose the raw data sheet has :
Name Tnumber TLApproval
AAA 11234 X
AAA 4567
AAA 3456
ABC 2345 X
ABC 8797

So the new Workbook should contain (output) :
Name Total
AAA 2 (excluding the row ,where 'X' is entered)
ABC 1 (same as above)

Please help me out in writing the macro for this .