How open are you to recording your data in a slightly different way thus opening analysis by Pivot Table?

i.e. Largely as now except that the month column would contain a proper Date number, e.g. always say the first of the month, and column M would contain the Reading.

Better still since you mention wanting to analyse data by energy type I'd suggest a column for the meter type, i.e. Gas, ELectric, Water and alongside it a column for the meter reference.

So altogether
Columns A:F as now
G: Meter Type, e.f.g Gas , Water Electricity
H: Meter Ref
I: Month e.g. 1/1/2021
J: Reading e.g. 2626251

Some of those columns could be drip down data validation to assist date entry

The way I normally arrange these things is to have a single data entry row above the database in which the new values are entered, then a button which runs a macro that adds the new record to the database.