It can be done using Worksheet Events, but you'll need to be a little more specific as to cells

E.g. in #1 you said state in Y7 and region in AD7

In #4 you said state in A3

I'd need to know the cells where you might put a state and the cells where the region goes