Idea for version 18.01 (i.e. would love this today...).
On the combine worksheets function, add an option to add the worksheet name as a column added to the front, or end, of every row. I.E.
Worksheet name: Apples
Column 1 name = "Color"
Row 1: Green
Row 2: Red
Worksheet name: Bananas
Column 1 name = "Color"
Row 1: Green
Row 2: Yellow
Row 3: Brown
Run combine, add worksheet name as leading column:
End result:
Worksheet name: Combined worksheet
Column 1: "Worksheet Name", Column 2: "Color"
Row 1: "Apples", "Green"
Row 2: "Apples", "Red"
Row 3: "Bananas", "Green"
Row 4: "Bananas", "Yellow"
Row 5: "Bananas", "Brown"
Lots of times I want the worksheet name as a piece of data in a column for each row. I have to manually fix that now by moving that 1 row added for each worksheet into a new column. I think this would be an easy add. You can thank me later