Many thanks !! this is super helpful. In reality I have a template which is around 12 pages that will require 7-8 Combo boxes + form that is segregated in 3 or 4 pages.

I tried to apply your model but I am new to VBA. What is my best bet here.