Copy and Paste values of other sheets using SUBTOTAL based on conditional formatting value

Dear Friends,

I have 7 sheets in total in a workbook.

I consider first sheet as "consolidation" sheet.

Remaining 6 sheets are have different data. However, in all those 6 sheets, Col E is having conditional formatting and if found, a specific color will be applied.

Now, I wish to have a macro to do the following:

1) Filter all sheets (except consolidation sheet) where Col E is having a specific color.
2) Then, copy the entire row(s) from there and fill it in "consolidation" sheet. (This copy should be done from all 6 sheets, and pasted in "consolidation" sheet one after other).
3) Remove "conditional Formatting" ONLY IN "consolidation" sheet (on the values just pasted).

Is it possible?

Pl help me.

Fast answers need clear examples.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

See here:

http://www.cpearson.com/Excel/CFColors.htm