Select the first sheet to copy. If all the sheets are together, hold shift while selectiing the last sheet to copy. If they are spread out, hold control while selecting each sheet to copy. With the desired sheets selected, Edit->Move or Copy Sheet...->work through dialog->OK and the selected sheets will copy. If that's not easy enough, you can modify Ron de Bruin's VBA code to do what you want.