Tab references don't shift in the manner you're expecting,
unfortunately. This would still be a manual change from month to
month. However, it doesn't take a lot of time, as you found out, and
you could set up all 12 months at one sitting- then copy the file to be
used next year and subsequent years, and the work would be done once
and for all.