Automate Excel Workbook on diet tracking

I have developed an Excel workbook to track the diet of my cat who has diabetics.I need to have this workbook automated with added data from the raw data entered into it. For example, data tables by protein, fat, fiber, etc. by month and day, by breakfast, lunch, etc., so going forward these tables can be auto populated as I enter the raw data for each day. These data tables should allow me to graph the data and perform data analysis.