vba excel automated task

following tasks :
1) Select a cocktail from the dropdown list
2) Display its ingredients, how to prepare it, and its price
3) Overview of today’s sales
4) Select a random cocktail
5) Sell the selected cocktail
6) At the end of the shift, save the sales to a hidden spreadsheet