Excel 2007 dynamic values sheet 1 on click

Good afternoon. I received help from this forum about 6 months ago on a difficult excel sheet and I'm hoping to get help again. I did some google searches, some searches on this forum and tried to swap some code based on the results but I'm still at square 1. Thank you in advance.

Workbook is attached. You will notice some yellow highlighted fields (sheet 1) that I would like for the values to be dynamically loaded (pulled from sheet 2) on the workbook being opened, then the results to change based on the user clicking on different options on sheet 1. The sheet 1 and sheet 2 values in fields that are *not* highlighted in yellow will be permanent, or manually changed.

There are some 'Totals' forumlas that I think can remain permanent. But that is assuming if the values change on sheet1, the permanent 'Total' formulas will recalculate on the fly.

I have a text box in the workbook with more explaination, but please if more is needed beyond what is mentioned there let me know.