Take Sheet1 layout and Create Sheet2 layout with Macro

Hi Experts,

Once again I have checked the forum, but have had no luck. I am attaching the spreadsheet that I am trying to complete with using a macro. I am trying to take a large, will be, file (sheet1) and make it into smaller subsets (sheet2) of the large file. Do any of you know if this is possible? I have on sheet2 a formula that calculates the total number of lines. I also have a cell that I say how many lines to put in each subset. I need it to keep "splitting" until the whole doc (sheet1) is broken up. I also need the total, highlighted orange, to reflect the numder of rows I set in the above step. Any help would be greatly appreciated. I have spent hours so far, and am getting nowhere.

Thans in advance.