How to combine multiple excel worksheet into single workbook?

There are more than 100 excel sheets in a workbook. How can I merge all sheets into single workbook? I don't want to read sheet one by one and concatenate because it'll consume time.

Answer 1

[dpb]

See the first "Related Content" link to the right of your question...

Alternatively, don't create multiple sheets in the first place if want the results all in one location.