Problem making multiple calendar pages

The problem is that your names JanSun1 etc are defined as workbook names. On the Formulas tab click Name Manager. You'll see that all the names have a 'scope' of workbook. This means that they apply to all sheets/tabs. What you need to do is re-define them all as worksheet-only names. Unfortunately, Excel doesn't let you do that directly - you have to re-create each one and set the scope then.

1. Use a file with just one, working, calendar sheet. Check that's it's working how you want it. (Note, it's usually best to work on a copy just to be safe.)
2. Go to the Name Manager.
3. Select the first Name (probably AprSun1). Note down that name (yes, it's the name of a Name - confusing) and copy what's in the Refers to box.
4. Delete that Name.
5. Click New.
6. Type the name you noted into the Name box and paste what you copied into the Refers to box. Do NOT click OK.
7. Change the Scope from Workbook to the name of the sheet you're working on - probably Calendar. Now you can click OK .
8. Repeat steps 3-7 for all of the Names. Close the Name Manager.
9. Re-check that the calendar is still working fine.
10. Copy the sheet. You'll now have another sheet which will have all the same Names but with a Scope which applies to the new sheet. The spin-button should now work on all sheets.

Hope that helps.

You're welcome, glad I could help. Thanks for the rep and for marking the thread Solved.