Macro to copy rows with red or yellow highlighted cell in column H

Hello everyone,

I am wondering if anyone can help me please.

I have a worksheet that has conditional formatting to show when a customer needs a service reminder, the list of customers will be upto 2000 so at any given time there maybe alot requiring a reminder. The conditional formatting shows column H, green as "ok", Yellow as "Service required within four weeks" and Red as "Service overdue". I would basically like a button that when pressed it opens up a sheet to collate all the complete rows of the yellows together and then a other sheet with the complete row of all the reds.

Is this even possible?

Any help or advice would be greatly appreciated.

Many Thanks

Jamie.c