I can't see how to do that without some programming.
What you can do is 'double up' though. This way you can create lots of
sheets fairly fast.
So,
(A) select a sheet, drag it sideways (left button), hold control (+ icon
shows), drop
(now you have 2 sheets)
(B) select the first sheet, hold down control and select the new sheet.
Release. Now you have 2 sheets selected (two white ones). Click on one of
them, drag it sideways, hold control (now you see +++ icon), release. (now
you have four sheets).
(C) now you need to do the same to double up those 4 sheets to 8 sheets.

You should be able to get to the number of sheets you need pretty quickly
like this.
--
Allllen


"Patch" wrote:

How are you all,

i was wondering if it was possible to copy more than one sheet at a time - i
have a work book and i need to make multiple copies of one particular sheet,
when i right click on a work sheet tab there are the options there - one of
them is move or copy - when you copy it askes where to put it, when you do
that it only comes up with one extra sheet - is it all possible to paste a
few more at a time than just one?

Thanks heaps Patchie