VBA code for a small health business (Required: searchable dropdown and buttons that generate a standard word template)

Hi, I am Mehul and I own a small health business based out of Delhi, India. The business involves providing nutrition plans and additional reports to our clients. Until now, I have been operating this business manually. But now, I want to expand and need to automate the whole process. I have already prepared a food database which includes the macro-nutrients and calorie count for all the common dishes consumed by our clients. Tasks: - Worksheet 1: Write a macro which can be used to select the dishes from the database using a searchable dropdown. The dishes selected should then automatically capture the macro-nutrients and calorie count of each. Then, we need a button in the ribbon which can be used to generate the nutritional diet plan of the client in a word document. - Worksheet 2: The same dropdown as in Worksheet 1 will be here. Also, we have already prepared a chart based on the specific inputs we take from the client. We need a button in the ribbon which can be used to generate a standard word template (already prepared by us) and the chart. -Worksheet 3: We input daily calorie intake numbers of our client in a separate worksheet. These numbers are the fed into this worksheet (Worksheet 3) and based on these numbers we have already prepared two charts. We need a button in the ribbon which can be used to generate a standard word template (already prepared by us) and these two charts. Note: We require a dynamic workbook which could incorporate the future changes in the charts/standard word template.