ComboBox values source being changed based on another combobox selection in a UserForm

I am in the midst of creating a UserForm in order to assist in adding daily bank transactions. I have two comboboxes on this userform (Category & Sub-Category) and I want to have the subcategories values populate to reflect the selected category. I've attached the file that I'm working with.

I have defined names for the following:

BudgetCategories ='Monthly Budget'!$AA$76:$AA$85

BudgetSubCategories ='Monthly Budget'!$B$8:$B$12,'Monthly Budget'!$B$17:$B$26,'Monthly Budget'!$B$29:$B$38,'Monthly Budget'!$B$41:$B$50,'Monthly Budget'!$B$53:$B$62,'Monthly Budget'!$B$65:$B$74,'Monthly Budget'!$B$77:$B$86,'Monthly Budget'!$B$89:$B$98,'Monthly Budget'!$B$101:$B$110,'Monthly Budget'!$B$113:$B$122,'Monthly Budget'!$B$125:$B$134


After all of the data is filled out completely in the UserForm, I want it to transfer the data to Sheet1 ("Daily Ledger") Starting at cell B6:G6 (*under the appropriate columns). Also, each new transaction should transfer the new data to then next empty row time after time whether hitting the "OK" or "Another Transaction".

I look forward to hearing some of the best wisdom out there.

Thanks!

This code does exactly what I was hoping, thank you for your assistance. However, I noticed that if I change the main category name on the worksheet the UserForm didn't work correctly. Is there a way have this list be populate the same way but have the ability for someone to rename the main category and sub category names?

i.e. Change cell 'Monthly Budget'!$B$16 from "Housing" to "Home", "House", etc. (*giving the user freedom of customizing titles applicable to them).