Steve,

for the invoices and other sequetial numbers
http://mcgimpsey.com/excel/udfs/sequentialnums.html

to duplicate a sheet click on the tab name press ctrl and drop to right.
Chip Person has a lot of tips to sort rename and etc
http://www.cpearson.com/excel/whatsnew.htm


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"STEVE" escreveu:

HOW CAN I DUPLICATE 1 SHEET INTO 40 SHEETS?

ALSO, HOW CAN I NAME THE SHEETS TO BE SEQUENTIAL?
(FOR INVOICES)
I WANT TO ASSIGN THE 1ST SHEET AN INVOICE NUMBER, THEN THE REST WILL
AUTOMATICALLY FILL IN SEQUENTIALLY.

THANK FOR HELPING!