User Selects "Yes or No". Based on this custom report generation

[Excelkris]

Folks.

Hope you are all doing great! Firstly, I would like to thank the folks who run this website. Seems to be a wealth of information on a wide variety of topics. I used google and landed up here. This is my first post.

Here is my question, with reference to attached spreadsheet.

In the "Input Form", I have column A - which basically is "Yes or No" (It will be great if i can have a slick form to enter that data, but thats ok for now). This is a user input for all the listed items. Must be mentioned, that if one selects Yes, then they will have to necessarily input values onto Columns GG2 through GG8

In the tab "Master Input", as of now, the way i have it is that Rows 4 & 5 contain key data (right now looking up only one value - the first row in the Input Form). I say it is key data, because there is rigorous calculations in Calculations tab, eventually summarizing the same in the "Summary Tab".

Is there a solution (macro and nice looking form), such that the summary is listed in either within a spreadsheet or say a word document for "all the items" where the "Yes" is selected in the Input Form.

Any help you all can provide will be immensely helpful. I am pretty well versed with Excel and general logic, but not strong either in VBA's, macros or forms.

Advance Thanks!

Very Sincerely,

Kris

[Excelkris]

Any help on this will be really appreciated folks!!!!