Cut and paste rows in a signle column to another sheet

So I need to search the attached page for rows starting at a specific value until an ending value, cut the rows, and paste on a new sheet.

So, in this example. I will search for the FIRST instance of "DEPAL" (Column contains the search values twice) and stop at the first instance of "SHEET TOTAL LABELS=>", cut every row from the "DAPAL" row to the 'SHEET TOTAL LABELS=>" row, and paste in an existing sheet. (we can call it "Sheet1", I can change it to fit.

Then I will do the same with "DPA1E" until "SHEET TOTAL LABELS=>" cut the same way. and paste in existing sheet.

"SHEET TOTAL LABELS=>" repeats after every section, so it would only go to the first one it comes across.

I appreciate the help. I get good information from the site, but don't have time to try to fisure this out myself. Have a deadline to meet.

So as per your attached sheet - rows 2 to 5 should go to sheet1, then rows 8 to 75 below the other data and then 78 to 85 below the existing data?

Yes i understand that part. The reason i specified the row numbers is to check if i have understood what you need.

Originally Posted by arlu1201

Yes i understand that part. The reason i specified the row numbers is to check if i have understood what you need.

Yes, that is what I need. But, the 2nd section would go to Sheet2 and the 3rd to Sheet3, etc.