Ok so I thought I had everything sorted with the spreadsheet I was making
until my line manager thought it would be a great idea to have a spreadsheet
that would archive itself at the end of the month and make a new version I
guess through a template for the new month. But whilst doing so use the last
values from the old spreadsheet to use as the first ones in the new
spreadsheet.

I'm now completely lost. Oh and they need to name themselves after the month
and year.

Any suggestions???