I have 5 motorised valves in my house and want the fifth motorised to
switch on when all four of the other motorised valves switch off, if
one of the four motorised valves is on the fifth motorised valve must
remain closed.

Perhaps you are in the market for an automatic bypass valve instead?

Christian.