Fill data based on multiple drop down selections on a heading page

Hello,

I am trying to get this vba code to work so that when a options is selected for the zone 1 drop down menu for instance if plank is selected itll put those rooms with a quantity on the plank page but if sheet vinyl is selected itl do the same thing. I just cant seem to get the code to work :/ ..... this is the code that i have and the attached workbook

Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws1 As Worksheet, ws2 As Worksheet
Dim rng As Range

Application.EnableEvents = False
If Not Intersect(Target, Range("H14:H18")) Is Nothing Then

Set ws1 = Worksheets("DEF_ZONES") ' tables of Rooms per Zone
Set ws2 = Worksheets(Target.Value) ' Product type e.g "Sheet Vinyl"
zone = Replace(Target.Offset(0, -1), " ", "_") ' Named Range of Zones
Set rng = ws1.Range(zone)
With ws2
irow = 14
Do While .Cells(irow, 2) <> "" ' find second blank cell
irow = irow + 1
Loop
For Each c In rng
.Cells(irow, 2) = c
irow = irow + 1
Next c
End With

End If

Application.EnableEvents = True

End Sub

Hello, the main problem I am having is for it to show the quantity with the zones in the quantity column and I had help making the code and I need the zones to show up with the rooms as well but im dumb and cant figure it out :/

they are on the PLANS-ZONES tab

That would be correct so it would be put in order as
zone 1
enry
powder
laundry
bath 2
total

on the excel sheet down in one columm and then lets says zone 2 is to go on the same sheet it would be in the same format just with one row left blank between the "total" from zone 1 and "zone 2"

Awesome! Thank you i really do appreciate your time into doing that for me. My one last question is how to i extend the VBA range so on the def-zones tab to get it to include the zones into it instead of just the rooms ?

Sorry i suppose that is what happens when someone who doenst really know how to explain it tries to explain it when they dont really understand the concept of how it works but im just wanting it to be so it also includes "zone 1" above the rooms instead of just having the rooms