Maybe keep each month's income in a single cell on the main "Source" sheet. I know this will result in a lot of cells but it will allow you to select individual months that you can SUM up on other sheets.
You can create a sheet for each year (Example "2019 to 2020") and each "Year" sheet will use different cells from the source sheet.
|