Is it possible to make a meal planner with these features?

I’m not an expert on excel by any means but I was wondering before I start even attempting to do this, can I create an excel that I add recipes and then have a tab for a weekly plan we’re it’s a drop down menu of all the meals I can pick from and when I pick the meal for Monday it adds the ingredients I need and how much?