October 4, 2021
November 8, 2013
Splitting data across multiple sheets is a bad idea, you will then need to aggregate data back in order to create reports.
Best is to insert data into one sheet only, you will have access to much more powerful tools to view reports, see sample attached. All you have to do is to add Month and Year column to the data structure you have, no need to separate into sheets.
You can even use a simple form to enter data, see an example here: https://www.myonlinetraininghu.....xcel-forms