Excel Macro/ VBA that can hide rows based on multiple criteria

I am new in this forum. I tried in vain to search my query with existing threads.

I would like to see if there is anyone can help to create a Macro for me.
My file contains Sheet "Sales 1" & "Sales 2"

Row 5- 7 of Sheet "Sales 1" has 3 sets of option boxes
If selected option in Row 5 (Tokyo) of Sheet "Sales 1" is "Yes", Row 10 if Sheet "Sales 2" is hidden
If selected options for all these 3 are "Yes", row 10 of Sheet "Sales2" is hidden

If the cell values in Sheet "Sales2" are
Year of service > = 1 year &
USD sales Amount > 50000
Type of Car = Honda
Q1 = "Y"
then Row 11-13 in Sheet "Sales 2" are hidden

Attached is the file