If Excel prompts you to save the save the file, click "Save" to continue. The "Select Files to Merge into Current Workbook" dialog window opens and displays a list of your Excel files.

A Microsoft Excel Workbook consisting of several worksheets can be split into individual files with minimal manual intervention. This can be done with the help of Excel Worksheet Separator: a powerful ...