Recipe Menu Planner macro doesn't seem to work!

Hi all!

I've downloaded an office file for recipe planning that seems to work fantastically, that is until I try and compile the shopping list. Instead of compiling the dropdown menu ingredients in the shopping list, the spreadsheet is compiling all the ingredients of every recipe in the spreadsheet. I found an error in the 'compiling' macro and changed it, but I still can't get it to only compile the recipes listed in the 'Meal Plan' sheet. I'm relatively new to Excel and I've spent days trying to figure this one out on my own ... but it's got me stumped. Wondering if anyone could offer a bit of help?

Cheers, Tam

Oops. Sorry about that!