Hi,

This assumes the first sheet is 2009 and the last 2019 and all the other
sheet are between those 2 sheets

= SUM('2009:2019'!A1)

Mike

"Vic" wrote:

my workbook consist of 10 one year expense tabs 2009 thru 2019 and a summary
tab.
i want the summary tab to tally the calender year expense as i copy the
summary tab from year to year. Every year tab uses the exact same cell from
year to year. the only difference is the the tab 2009, 2010, 2011, etc