Selecting rows between cells of text value

[Tortus]

example.xlsxI can't figure something out and need some help. I have a text file in excel and I need to capture all the text between 3 values (actually between 2 of the 3). The 3 values are all in column D.

If "Released" is found in column D5, I want to grab entire row A5 through all rows until "Released", "Progress" or "Approved" is found again in column D. If "Released" is found again in column D, keep the copy going, stop at 1 row above "Progress" or "Approved".

Anytime "Released" is found in column D, copy that data and move to next blank cells in sheet2 and paste!

Thank you!