FANtastic! Your suggested code changes are pretty much exactly what I looking for - thank you so much!

If you're able to further indulge me I would really appreciate it if you could assist me with just working this bit - I didn't think this bit thru properly when I attached the original spreadsheet late last night.

In the spreadsheet I previously attached the sheet names were as follows:
Sheet2 (Section 2)
Sheet3 (Section 1)
Sheet4 (Section 3)

what if in the production spreadsheet the sheet names were something similar to these:

Sheet2 (Report template - Advanced)
Sheet3 (Report template - NextGen)
Sheet4 (Report template - All Future)

and the Option buttons in the UserForm were these caption names:
OptionButton1 (NextGen)
OptionButton2 (Advanced)
OptionButton3 (All Future)