Select ros that contain specific value in column along with any blank cells below in same column to cut to new workbook

[zigojacko]

To save a lot of time, I'd like to come up with a way to select all rows that contain a certain cell value in column D plus every blank cell in the same column below. I then want to cut all these rows and paste them into a new workbook.

As an example, my data could look like (I have highlighted red the data that I wish to cut from sheet):-

A	B	C	D	E	F
A Header	B Header	C Header	D Header	E Header	F Header
123			simple	fdbdfb	dfgbdg
123			simple	dfsdf	dsghsd
123			configurable	dfgsdg	sdgsds
123			simple	olihil	l'ph'olib
123			configurable	gfjfgjg	gfjfgjfg
123					ghkghjkg
123					dsgsdgsd
123					fdgdsgd
123					dsgsdgsd
123					sdgsdfgsd
123					sdfsafs
123			simple	sdfsdfs	sfsafsa
123			simple	safas	sfasfsaf
123			simple	safasfasf	safsafsafsa
123			configurable	sfasfsa	safasfas
123					dfgdfhdf
123					fdhgdf
123			simple	gdsgsdgs	cdgdghdf
123			configurable	sdgsdgsd	dfgdgdf
123					dsgsdgds
123					gdfgdsg
123					sdgsdgsdg
123					sdgsdgsd
123					gsdgsdgg
123			configurable	dgdgd	dgdfsgsdfg
123					fdgdfgdfg
123					dfgdfgdfg
123					dfgdfg
123					dfgdfg
123					dfgdfg
123					dfgdfgdf
123					gdfgdfgdf
123			simple	fgfdgdsfg	gdfgdfg
123			configurable	dsfgsdfgdsf	dfgdfgdfg
123			configurable	gdfsgdfg	dfgfdgfd
123			configurable	dsfgsdfgsdf	gdfgdfg
123					gdfgdfgdfg
123					gdfgdf
123					fdgdfgdf
123					gdfgdfgdg
123			simple	fhdfhfh	dfgdf
123			simple	gfjhgkjjh	dgsdgdfg
123			configurable	sdgsdgs	dfgdfs
123					fgdsgdfg
123					sdfsdfsd
123					gsdfgfds
123					dgfdsgdsf
123					dsfsdgsdg

<tbody>
</tbody>

I'm not entirely sure if there is a formula that can achieve this? But I'd be so grateful if anyone can provide the quickest way to achieve this.

Should say rows in title instead of ros, apologies I didn't spot the typo before I posted (please could this be amended, I could not see the option to edit myself).