Is there a way to split an Excel sheet into multiple worksheets by subtotaled sections?

[Michigander]

Does anyone know of a macro or any option that will separate a large one-sheet workbook into multiple worksheets (tabs) or separate workbooks by the subtotals? One of the platforms that we use allows us to export to excel with locations subtotaled; however, it's all included in one sheet and we need each subtotaled section to have its own worksheet (or separate workbook). We're doing this monthly and it would be awesome if any of you have ideas that you could share with me.

I've seen the options and the great macro that was created to separate a worksheet into multiple workbooks by a specific number or rows or columns; the issue with that is that each subtotaled section doesn't have the same number of rows. The first subtotaled section could have 3 rows, while the next section has 300