I'm not sure how far I can go on this project so I'll take it step-by-step and question by question.
I have a client who tracks costs by project - each project has its own workbook with a tab for Consolidate and 12 tabs for each month.
Projects can go over from one year to another. When that happens they would like to append a template at the end of the current workbook for the next year.
I have attached two workbooks - the one labeled Project Cost Allocation that will be appended at the end by the file labeled Appending Workbook (this is not a template file at this time.)
What I'm hoping is for a macro labeled Append for the user to click on. If I can get that far I'll open another question on what to do with the appended file to the current workbook.