Find rows to delete with a macro based on cell content

[mkraffert]

I've written a macro to create 2 worksheets containing data from a 3rd worksheet. My macro works fine, but it's "stupid". I manually selected rows on new worksheet for deletion. I can't figure out a way to have the macro delete the rows based on the contents of the cell in column A. How can I have the macro automatically determine which rows to delete? I've attached a copy of the spreadsheet with dummy data so you can see what I'm trying to do. I can't use a formula to do this because it won't pick up the background color formatting. Also, each entry on the first sheet could have anywhere from 1-3 rows depending on the type of change being documented. The only constants are the contents of the cells in column A.

Thanks.