Populate & Calculate Values in Main Sheet from Table

Hello all,

Firstly, pardon the title. I'm so bad at excel that I don't even know what exactly to ask for. If I knew I would have had better luck learning how to do this on YouTube. Preferably I just like someone to actually program the worksheet and post it back to me, but any help is great. Thanks in advance for the help.

See attached file... I've made a worksheet that I want to use to track the daily routines of my new diet & exercise routine. Here's how I want the sheet to perform:

GREEN COLUMNS:
1. when I click on any cell in the "Drink" column that a drop down list appears allowing me to select any item in column R
2. once that item is selected, and I've entered a value in the "# of 16ox Servings" column, that the calories are automatically calculated and appear in the corresponding cell in Column D
Note: the items in the reference table are going to changing constantly

ORANGE COLUMNS:
- same as green
JUICING WORKSHEET.xlsx

Select B2. Go to Data --> Data Validation. In the "Allow" drop down, select "List". Click in the "Source" box that appears, and type in =$R$2:$R$32. Alternatively, select that range with the mouse. Click OK. Copy and paste as far down and your heart desires.

In D, you want to enter the following formula:
=IFERROR(INDEX($R$2:$S$32,MATCH(B3,$R$2:$R$32,0),2)*C3,)

Copy and paste to your hearts content.

Repeat for Columns E and G, adjusting as necessary.