If you have a large workbooks that you need to split into individual files- one for each worksheet and each filename needs to be the worksheet name and should be saved in the same path as the original workbook,You need Excel Workbook Splitter.

Step 1:Download Excel Work Book Splitter and install.(Make sure you already intalled Microsoft Excel 2000 or higher)

Step 2: Now run the EWS software. The program window will appear.

Step 3:Click Add file button,you can add Excel file or add folder.

Step 4:Select a output folder,then click "OK",Now the Excel files are on the list.

Step 5:Click "Split" button,few seconds later you'll get splitted files.