Solution : How to convert excel sheets in to different workbooks

Open existing excel file

 Pres Alt + F11 to open Microsoft Visual Basic Application

 

Right click on VBA Project on right side - Insert - Module

 

Insert a following code on a module

Sub Splitbook()

Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
    xWs.Copy
    Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls"
    Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

Run this code 

Check a current folder where your file is saved

You will get new files.

Finish