Searching Sheets in Numbers to Total an Amount

Im building a cookbook for a restaurant that I work at in Numbers and need to total the amount of supplies I need for an ordering guide. The ordering guide is as follows: I want the green cell to be the total amount of that ingredient. Each sheet in the book is a different recipe, like this: I just want the par guide to grab the "Scaled Amount" for each ingredient and add them together, so I know how much to buy. Im hoping for it to do this automatically, so Im not manually looking for each cell to add to a total, instead using something like VLOOKUP to combine totals.