Seperating a Master sheet into two worksheets defined by a catagory assigned to each row

Hi there,

I have a Mastersheet with each row categorized as either 'C' or 'D'. I would like two worksheets for each category. One for rows categorized as 'C' and one for rows categorized as 'D'.

The Mastersheet will be updated on a daily basis. Rows will be deleted throughout as jobs are completed, but rows will only be added to the bottom of the page.

Here is a sample of the worksheet.

Thank you!

Julie