Consolidate multiple sheets on one worksheet

[Mich8261]

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

[#2 · Accepted solution]

Hi @Mich8261,

You can use Power Query to seal the deal "Best Solution"

Here is link that might be helpful for you 

https://www.youtube.com/watch?v=F5fjv6nXvZo

Also there is also a VBA solution, which you can find it here  

https://excelexciting.com/combine-active-workbook-all-sheets-into-one-master-sheet-with-vba/

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

[#3]

Thank you Faraz. I have watched the video and this is exactly what I need.