Formula help for match to return corresponding row values

Hi experts,
I'm new here and not bad at Excel in general.
I am having this issue.

Column A - contains unit #
Column B - contains owner
Column C - contains customer
Column D - contains district
Column E - contains type
Column F - contains date
Column G - contains a number
Column H - contains contact info
Column I - contains notes

The data above starts in row 4 and the data reaches to row 141.

I want to search column D and if the cell value matches my supplied value, return the corresponding values of cells A-I in the row where the district shows a match.
I need to match all values in column D and return the data to a new spreadsheet without blank spaces. In other words, match a value from column D, pull corresponding data from A,B,C,E,F,G,H and I and fill those pieces of data into a row on the new sheet while only filling as many columns as the data matched. I have been playing around and I have this formula in a cell on my new spreadsheet:
=INDEX(A4:I4,MATCH("ETX",$D$4:$D$141,0),0)

This works as far as pulling the data and placing it in the proper rows. But I can't seem to get it to continue looking, matching the value and bringing the remaining data from cells A:5 to I:141. I am pretty sure I need a IFERROR, AGGREGATE and a count function but alas, this seems to be over my head.

Sample Data

A B C D E F G H I
_____________________________________________________________________________________________
Unit# | Owner | Customer | District | type | date | Days passed | Contact | Notes
4 1 M1 Brown ETX No Info No Info Trent Davis Sold
5 2 M1 Brown WTX post job 10/8/2019 65 Richard Jones
6 3 M1 J&K NE 6 Month 7/26/2019 139 Tyler Crow Sold
7 4 M1 J&K NE 2 Month 4/11/2019 245 Tyler Crow
8 5 M1 Brown ETX post job 10/10/2019 63 Trent Davis

My formula pulls all the data from row 4 and places it in the new sheet because column D matched ETX.
But I can't get the formula to continue. I need it to ignore any instances in column D that are not ETX and when it sees the next matching value (in this case row 8), pull the data from row 8 and place it under the previous result.

I'm hoping somebody here can help me out.
Best regards!

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Or you could use a pivot table. select all data in proper order, add it in the pivot, then go to Design - Subtotals do not show, Report Layout - Tabular. And filter the District column.