Creating new excel files from current file

Short answer: yes! For example, if your worksheet has records organized by, say, month, you could write a loop that would copy a block of records for each month, copy to a new workbook and save/name the new book with the month name.
Missing: a detailed description of the workbook layout and the parameters that would delineate the data into new workbooks.