I need a dynamic product order sheet

General information for the business: We sell flower arrangements
Industry: Art and Design
Description of excel work: I need an excel order sheet (if possible in google sheets). Function is very simple.

I will give you a list of flower arrangements and its recipe of flowers (including name of flower and Qty in the arrangement)

I need a dashboard that allows me to select the Flower Arrangement and Qty, and spit out the recipe (Flower and Qty). The dashboard will allow me to enter multiple flower arrangements and # needed. The final output will be the summation of all the flowers and the qty needed.
Extra notes: Example:

I give you 2 arrangements.

Arrangement Name: Rose Bouquet
Recipe: 12x Red Roses, 6x Green Leaves

Arrangement Name: Sunflower Centerpiece
Recipe: 3x Sunflowers, 2x Red Berries, 5x Green Leaves

Create a database with the recipes I give you. Then create a dashboard that will allow me to select arrangement.

Dashboard Mockup

*Select an arrangement (drop down)
Rose Bouquet
**Enter Qty
2

*Select another arrangement (drop down) or if complete, hit done
Sunflower Centerpiece
*Enter Qty
1

*Select another arrangement (drop down) or if complete, hit done
done

Output
24x Red Roses
17x Green Leaves
3x Sunflowers
2x Red Berries