Hello,
Combo boxes with validation range defined in sheet 2 seems to be the easiest way.
I have experience with vba, so, waiting 1s and delete content from a few cells is quite an easy job, that's why my bid is low.
If you want a good quality for this template, delivered in short time and low price, please consider my bid.
Best Regards,
Constantin Plaiasu