How do I set up a master sheet in a workbook that compiles data from the other sheets?

I have a workbook with multiple sheets that track inputted data and what their status is (i.e. Open or Closed). I would like to make a master sheet that would import data from each of these sheets automatically. In particular, I want the sheet to only import and display the "open" files. I also only need to apply this to 5 of the worksheets in my workbook.

I've attached a modified version of my workbook so that you can see what I'm trying to accomplish. Ultimately, the master sheet would look identical to my other sheets just without the closed or canceled items.

Thanks for helping me with my problem.