Rather than use the multiple sheets and books. Have you considered using a single book for all years and a sheet where you select the year and month with a side panel for the annual summary?