Formulas to calculate multiple data validation responses

Hello,

I am in search of assistance in creating formulas that will help me ultimately aggregate a bunch of data and create a quick reference dashboard to view the summary of user inputs. I have attached an example workbook that explains what I am looking for. Essentially, it will require quite a few dependencies but I'm not quite sure what the most efficient and effective way would be to collect and analyze the data points. For example, in one section users should be able to select multiple selections given a list of options, but I don't know how I would do that and implement some of the things I am looking for.

Feel free to ask for clarification- it may seem a bit convoluted but I tried to explain it in the easiest way possible.

Thanks