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.