We have over 20 worksheets that are created from another application. We
would like to copy them into one workbook so that the names of the original
worksheets appear as tabs in the new workbook.

Any suggestions?