I have a workbook for each detective in our department. Each workbook has 52
sheets for the weeks for this year 2008. I have copied all these workbooks
into a new folder for 2009 and created a new 2009 date sheet that links and
changes all the dates. Question: Each sheet has the correct date for 2009 ,
but the data is still showing on all the sheets from the 2008 year. How can
I remove the data from each of the sheets or should I have done this
differently?