sorting data based on depth ranges

Good Day

I have data in sheet 1 which I want to sort in sheet 2 based on depth ranges, by giving chainage,diameter, trench width and depth. For example at chainage -370.59 diameter is 916,width is 2.1,depth is 0.34m and length is 0.0m. All this info must go to depth range 0-2m.

Your help will be highly appreciated