Hi Andrew-R,

Thanks for taking the time out to reply to me.

I dont have much experience with macros. The only time I have used them was to create a button and assign a macro to redirect to another sheet within the workbook. I am always looking for new things to learn though so would be open to suggestions.

Also, if you think adding a year reference somewhere in the sheet would help, by all means do so. The only thing I really need to keep the same is the range of cells (B6:AF10). Dates etc, can be placed elsewhere in the sheet if needed.