Nov 02 2021 10:09 AM
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
Nov 03 2021 02:31 AM - edited Nov 03 2021 02:46 AM
SolutionHi @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.
Nov 03 2021 09:22 AM
Nov 03 2021 02:31 AM - edited Nov 03 2021 02:46 AM
SolutionHi @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.