I tried the data you were given, the feature worked ok. The steps below is how I did this:
1. Under Kutools Plus
tab, find the group Workbooks & Sheets
. Click Combine
2. Select the first option
, then click Next
3. Select the worksheets that you want to combine, then click Next
4. In the Step 3 of 3, please select Combine by row
for Combine mode; Set 1
as number of header rows and 0
for number of total rows (total rows mean the row that sums the values up). And pick the options you need for other sections. See screenhot:
5. Click Finish
, and save the newly combined sheet anywhere you like.
6. A pop-up dialog asks if you want to save the scenario, click Yes
7. Now, a new worksheet is created showing you path to the combined sheet. You can just click it to see the sheet.