My workbook is having 4 sheets. Sheet "A", "B", "C" & "D". Need to split the the workbook into multiple workbooks with each 25 rows.

When splitting the Sheet "A" the file name should be saved as Sheet 1 A.xls, Sheet 2 A.xls like that when it take data from Sheet "B", it should continue with Sheet 3 B.xls and same way it should do for other sheets also.

With my VBA knowledge I am not able to do this. But I am in need for help very badly. Will I get help?