Macro to copy from a template to worksheets from a list of worksheets

Hello all. This is my first post! I've been scouring the internet for a solution to my question and have found nothing yet. I know what I want to do, but can't for the life of me figure out how to get it done. Here's what I have: A workbook to keep track of employees vacation hours, sick time, etc. Each employee has a worksheet with a calendar on it and the previous year below the current year. I have an index page with the employee list and links to each sheet for each employee. at the beginning of next year I want to be able to run a script that will take the 2018 calendar and move it to the 2017 position and then copy a 2019 calendar from a template and put it where the 2018 one was. But I want to do this for every employee sheet. Here's a brief summary of what needs to happen:

List of worksheets to be edited on “Employees” Sheet. range A3:Axxx


Go to employee sheet from list.
Copy cells. B7:BK30
Paste cells further down sheet (B46:BK69).
Then go to “Calendar” sheet.
Copy cells. B7:BK30
Return to previous sheet and paste to same range as above. (Replace B7:BK30 with data and formatting
from “Calendar” B7:BK30)
Then perform same operations on the next sheet on the list.
Repeat for all sheets on the list.
Could be up to 85 sheets to edit.

Sorry for the long post, but I wanted to be thorough. Thanks for any help!

I've attached a sample workbook. The "291" worksheet is what the sheets currently look like. The "291 after date change" worksheet is what I'd like them to look like after the macro. Where the top calendar is moved down to replace the bottom calendar and then the top calendar replaced with the calendar from the "Calendar" sheet. The list of sheets to perform this task on is on the "Employees" tab.

So I found some code and modified it to get some of what I need done. The New_Year macro will move the calendars down on all sheets from the list. Now I need to figure out how to copy the calendar template to each sheet using the same macro.

Please see attached.

Solved this one myself! If anyone is interested in the code, let me know and I'll post it.