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.