I am using the formula =COUNTIF('Jan-06'!$D$3:$D$500,"Sales"). We copy the
data down within the same spreadsheet to create one for the new year. The
Jan-06 is based on the tab name, therefore when the year changes to 2007 the
added new tab will be Jan-07. This is used for all 12 months in 12 columns
with the "Sales" changing for each item that needs counting. Is there a way
to create a formula that when the year is changed in the first formula in
Column B5, the year in every formula in the spreadsheet is changed within
that section only?