Going by the very limited information you gave, I would just save your
current workbook as "bill payment for 2010.xls" (or whatever you want to
name it). Then I would rename the tabs and edit the individual worksheets to
suit 2010.

"b1hughes" wrote:

I have a set of excel work sheets for the 12 months of 2009 and I want to use
the same sheets with same data for 2010. How do I copy the sheets into a new
work book titles bill payment for 2010?

Thank you.