Copy data from one cell based on color of another cell to a different worksheet

I have an Excel 2010 spreadsheet consisting of many worksheets (20 or so). Each of these worksheets contain detail level data regarding different projects. One of the columns in these worksheets is the 'Status' column (column F). There is conditional formatting on this column where if the text is 'G' then change background to a green color, 'Y'=yellow, 'R'=Red and 'U'=Grey.

The first worksheet is a summary sheet that I would like to pull information from each of the detail worksheet's columns B, D, E, G and H if the status column (Column F) is 'R' or 'Y'.

The number of rows in the detail worksheet can change each week (as few as 0 and as many as 100)

I am not versed in VBA so if there is a VBA solution to this, then I will need help developing it.

Any help would be greatly appreciated.

Jeff

FDibbins,

Thank you for your reply, however, the countif and sumif (from what I can see) will provide a numeric value to how many rows meet the condition. I am looking to copy certain cells from those rows to another worksheet based on the color of a cell.

Thanks, Jeff