Lets say the first worksheet of my workbook contains names (Nikki, Alex, Lexus, …) in rows & types of medication in columns. And the cells record amount of particular prescription (type of medication) assigned to a given kid at a given date (I have gotten help on building a calendar, thank you guys for that!).

Anyways, I would like to be able to enter medication amounts for every kid every day & store that information somewhere with push of a button (assigned macro…) – next worksheet of the same workbook?

Also, I need to be able to retrieve medication data for the previous days (given they have been recorded)

Here are my questions:
1. how do I store information entered everyday so it can be retrieved? I have learned macros abit & still in need for guidance on how to store the data; you don’t need to do everything for me, just provide with the guidance or with a link where I can learn.
2. would PivotTables of any help to store that data in an organized manner?
3. How do I pull that everyday stored information?

Thank you