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 ...

excel

ExcelExciting
Nov 03, 2021
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.