Are Automatic Food Costing Sheets possible with Excel?

Hi guys,

I swear many moons ago someone taught me how to run food costing sheets so that you have a main sheet with ingredient costings and then you have a recipe sheet and you can link the ingredients between sheets so it auto calculates.

I can not for the life of me figure it out. If this is possible and my brains not making it up any advice would be HUGELY APPRECIATED because im kinda old school and would prefer not to use an app or whatever.

Please and thank you for any help given 😁