List for for same dropdown

Try this by clicking on show Form3 in attached workbook
This works because Named Ranges have been set up to match the dropdown values in the previous box
Works like =INDIRECT formula with cell dependant dropdowns

Private Sub UserForm_Initialize()
Me.ListBox1.RowSource = "Division"
End Sub

Private Sub listBox1_Change()
    Me.ListBox2.RowSource = Me.ListBox1.Value
End Sub

Private Sub listBox2_Change()
    Me.ListBox3.RowSource = Me.ListBox2.Value
End Sub

Late EDIT
you could use comboboxes instead of listboxes - just amend the code to match their names