Create a data validation that will fill multiple columns

First off, I sincerely apologize if I am in the wrong section, what I am asking for is not possible, or I have completely butchered something. There was a time I got along with Excel very well, but now that I've switched over to a Mac and the new Excel 2011 is different than I remember, I am completely lost... Though, I'm not sure I would have been able to do this in Excel 2007 either.

I've attached a workbook of a project I am currently working on for one of my Kinesiology class's in hopes of some help. Needless to say I didn't think about the Excel aspect of the project before I started.

What I would like is for the user to be able to select an entry (a specific food in this case) and have the following columns filled out based on the first sheet 'Food'. So if the user picked '8 oz skim milk' from the drop down list, the following columns of nutritional facts for the different days within the different worksheets will be filled out according to the information provided on the 'Food' sheet.

I would like the user to be able to add their own choices of food, and update the nutritional columns accordingly as well.

Again, I apologize if this has been addressed in a previous thread- I'm still not even sure using data validation is the correct way I should be going about this. Not sure if it matters, but I am using Microsoft Office 2011 for Mac. Thank ya'll for any help.

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.