Macro to seperate and copy rows based on start and end cell text

[s0nicstang]

I am trying to pull sections of a spreadsheet and seperate them into seperate tabs. Looking for a macro that can say look for a specified text string then copy all rows down to another text string. Example

Start Text String

Row 2
Row 3
Row 4
Row 5
Row 6
Row 7

Start Text String

I need to copy all the rows in the middle (or include the top and bottom strings doesnt really matter) and paste them to another sheet. Then go to the next instance where it says the string and copy those rows.

So below one sheet will have rows 2-7, another sheet will have rows 8-11. Is this possible? Thanks

Start Text String

Row 2
Row 3
Row 4
Row 5
Row 6
Row 7

Start Text String


Row 8
Row 9
Row 10
Row 11

Start Text String

 

[s0nicstang]

Anyone know if this is possible?