Hello all.

I work in a theme park and I have a spreadsheet that has status of effects broken down by area. Each page is a seperate area. Column B on every page lists the effect status (Either OOS, or In Service).

I would like to add a summary page that will search the rest of the pages and any which column B has 'OOS' in it, add the whole line to the list on the summary page (So I can have a summary of all effects that are out of service).

Is there an easy way to do this?

Any help appreciated.