Copy from page one to page two based on cell colour

[shorie7]

Hello all... Again.
I need to have the last 12 full weeks I worked copied onto page two in my worksheet.
Can I ask, would it be possible, to copy the last 12 full weeks from page one, onto page two automatically? I need to keep updating page 2 for the last 12 weeks that I worked 38 hours or more. The weeks on page one are conditionally formated to turn red at 38 hours or more. At the moment, I am manually having to copy and paste the last 12 rows that contain a red cell from page one to page two. My holiday pay is based on my last 12 FULL weeks money, so I need it because the agency keeps getting it wrong. Is there a way of doing this please? Any help would be greatly appreciated. Thank you.

[jason.b75]

Didn't realise you had started a new thread for this question, I've posted an answer in your vlookup #value error thread where you had this tacked onto the end.