You might also try searching the newsgroup archives using Google:
http://groups.google.com/group/micro...ramming/topics
Enter the search term "copy rename worksheet".

I found a post titled "Button to copy sheet, rename sheet sequencially."
[sic]:
http://groups.google.com/group/micro...db28d421e8237b
Scroll to the bottom to see a reply posted by Dave Peterson on Jun 17 2005
7:41 am that is pretty close to what you need to get started.

--
Regards,
Bill Renaud