Paste Worksheet As Values?

I am trying to create a sub that:

1) Copies the values of a worksheet/group of worksheets from one workbook and

2) Creates another workbook titled as Today's date (i.e., Workbook_011512)

3) Pastes these sheets into the workbook and

4) Deletes a specified row (i.e., if Column A says "cat", delete that row)

5) Reformats in the same alternating pattern as before (this sometimes gets messed up when the row gets deleted).

My data is formatted with alternating colors in a couple worksheets, and looks kind of like this:

dog 1 2 5
dog 1 2 3
cat 1 2 2
dog 3 4 5
Median 1 2 4

dog 1 4 6
giraffe 3 5 6
cat 3 6 2
Median 3 4 6
etc etc.