Summarising data

Sample Workbook.xlsI have a file with three sheets listing a number of assets in three different regions.

These assets have risks associated with them and are coded : Red, Amber and Green (original I know!).

What I would like is a 4th summary sheet that contains all the red and amber risks from the other sheets and I would like this to auto populate. I will have a different manager that is responsible for a different region I I will use the summary sheet to get a global view of all my risks... I hope this is making sense?

Anyway... I have attached a simple sample workbook. The risk summary sheet is what I would like help with as I don't want to filter through the other pages and cut and paste every week.

Can you help?

Hi

A small sample workbook could helps us.