How to make a dropdown list pull data from another sheet and autofill underneath the list.

I have a dropdown list for days of the week, for example Monday, Tuesday,...Sunday Etc. I want to be able to select a value from my list and it fills the 10 cells below it with data from sheet 2.
I want to have different data that is filled based upon the value selected, for instance if I select monday I want the 10 cells below it to say Hot Dog, Hamburger, or Pizza. If I select Tuesday I want it to say Brocolli, Squash, or salad. I would place those values on sheet two, but what is the command to accomplish this function?

If I understand you correctly, you'll want to do this:

1. In sheet2, you'll have two columns (A and B). In column A you'll list Monday1 Monday2 Monday3 all the way to Monday10, Tuesday1 Tuesday2 Tuesday3 all the way to Tuesday10, etc. In column B you'll put the 10 foods for each day. So B1 would be the food for Monday1.
2. In sheet1 put your dropdown list in B1. In A2 through A11 you'll have the numbers 1 through 10. In B2 through B11 you'll have a formaula that looks up the data (the foods) in sheet2 column B.
3. Using a VLOOKUP, your formula would be something like this: =VLOOKUP($B$1&$A2,sheet2!$A$1:$B$70,2,FALSE)

Hopefully that's what you meant.

I tried to get it to work, but instead I made a copy of my current sheet, and I want to see if you can help me out by possibly fixing up my formulas Example.xlsx

Example_2.xlsxAttached.

Fixed your named range CLASSES, made two new columns (highlighted in yellow), and put formulas in the cells beneath the drop down.

You have helped me out tremendously. Thank you so much!