Preventing value change in Cells based on criteria on another cell

Please note, the limitation is must enter data in an order from C2, C3, C4 and C6.
If user enter in other order (or reverse) it can not control the data (VBA should be use in this case)

Change data validation of C4 to
=IF(OR(C3="UPI",C3="Wallet"),C4,ROI!$A$2:$A$14)

and C6 to
=IF(OR(C3="UPI",C3="Wallet"),C6,Tenure!$A$1:$A$5)

Then set protect worksheet.
** Need to keep form unchanged or to be original value before use for next clients.

Regards.