Populating # values based on multiple text answers

Hi everyone! I am posting this again because I posted it before, but didn't explain it very well and someone suggested I add a dummy worksheet along with it so here I am again!

Okay, so the company I work for has just switched over to a new company with different policies and procedures. Our old company had global policies and procedures and this one does not, meaning that every different part requires different case of documentation. Ex: If you are buying from China and shipping to Mexico there are different documents than buying from China and shipping to US, whereas before it was all the same document just translated into different languages. That being said there are five questions that will need to be answered in order to find out what three documents will need to be used. The answers to the questions will be drop down selections, and text format. The results or answers I want them to populate (the documents) will be numeric values.

Again I attached a dummy document, this is not how the format needs to be. Ex: if you think it's easier to list out all the documents and have a value saying yes or no next to it that is fine! Preferred being that they answer all the questions and it populates itself.

Also one last thing: I am leaving this company next week but am trying to finish this up for them. Obviously I am willing to work with any solution but the easier it can be explained to the person that is taking over my position the better. Also I am pretty new to excel, so I am willing to learn anything but please explain it in layman's terms (as best as possible) haha. THANK YOU SO MUCH!!!! this is really appreciated(:

Hello,

First of all thank you for your help! I guess I did a bad job explaining once again, but the three number values I would populate in the end are based of the answers to all five questions. So I see what you did there with the second sheet, but the first questions answer does not determine the # value, the answers to 1-5 does. Please let me know if you need any further explanation!