Create New Worksheets and move data Based on repeating Text Value

[Dawn_B]

I have attached an example of a file that I want to extract data from the original worksheet based on repeating text values and create a new worksheet and copy text to new worksheets. In the attached example I need a macro to create 4 new worksheets based on the repeating Header highlighted in orange. I need a new worksheet for rows 1 to 91, rows 92-194, 195-285, and 286-406.

 

[Larry Haydn]

Please attach the whole worksheet (400+ rows?), AND include the row numbers in your image.
This is so I can tell which headings that you are looking for in order to split the report into 4 worksheets.
The macro would be very simple. I can provide the codes after that.