Excel:

I'm trying to create a dynamic summary page, which holds the values of all records, which have a status of "open".
All work sheets have the same number of columns, but I don't know how many rows or worksheets there will be.

If I change the status from "open" to "closed" I want the row to be automatically removed from the list and vice versa.

Any help will be greatly appreciated

Regards Al