looking to copy a row of data onto a seperate sheet by selecting a category from a drop box

eg.
sheet 1
date description debit credit balance category
dec 15 2012 Paint Store 50 20000 M

Sheet 2

Materials Expense
date description total
dec 15 2012 Paint Store 50