Combine (Append) Multiple Excel Sheets from Multiple Excel Files with Varying Number of Sheets

The simple technique to combine (append) multiple Excel worksheet from multiple Excel files

with varying number of worksheet in each workbook.

Source Datasets

Excel File 1 > Sheet 1, Sheet 2

Excel File 2 > Sheet 1, Sheet 2, Sheet 3

Result

All 5 Sheets appended table.