Copy rows based on cell value "Open" from multiple sheets

[Excelme at work]

I have a workbook with multiple tabs which each represent a different workstream / working group.
Each tab is effectively an action tracker based on each meeting group.

I would like a summary page to search for all items that are listed as "open" in Column i, and then copy the entire rows to the summary sheet.
I would need this function to search all the tabs for each workstream and then create 1 open action list.

Is this possible?

 

[Michael M]

See my last post #19
It means you don't need a delete or refresh button !