Try this
http://www.rondebruin.nl/copy6.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Sharon" <Sharon @discussions.microsoft.com wrote in message ...
I have a workbook with ~40 individual spreadsheets. Now I am moving them all
individually and spending tons of time. Is there a way to separate each
spreadsheet into its own workbook at the same time?