Calorie & Macro Spreadsheet in Google Sheets

Job ID: 35193543

Budget: $10 – $30 AUD

I have a database of recipe names (which I add to weekly) I have the total amounts of calories, protein, carbs & fats for each recipe.
With each of my clients I adjust their calories and macro intake every couple of weeks so I need to give them different recipes.
I would like to have a separate sheet where I can add in the meals I plan to give them and it adds up the calories etc as I go so I can make sure it adds up to their targets.
I would like it to be super easy to add in new recipe names weekly too (not have to update formulas each time as I have no idea!)
Related categories: Visual Basic Data Processing Data Entry Excel