Take Certain Cells and Display in Rows

Hello,

In Sheet 1, Colum D:H, I have firstly in D10 a vessel name and then below a box number dependent on the specie (Column B) and the size (Column c).
In sheet 4 I wish to only display the cells that have box numbers in them and display them in row order, As there is 12 Species i thought 6 species per side.
I have mocked up an example of what im trying to achieve in sheet 4. For each Vessel D10, E10 ... Etc i would then have them dispalyed underneath.

Im using a 365 package version 2205