Consolidate multiple sheets on one worksheet

I use a simple log to track client tasks, incidents, and basic projects. There’s less then a dozen columns which include some free form text (e.g. comment or issue description), dates (creation, due date), and some items restricted to a drop down list (category and status). The log is the same for all clients. I plan to move all client logs into a single Excel document (one tab per client). I would like to have a main tab where the information from each tab is visible which also allows me to filter based on status and/or category. 

thank you in advance