Try this example Sesh
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sesh" wrote in message ...
Hi,
I have a 30 work books and each book has 5 sheets.
I want to copy the first sheet from each work book to a single work book
'A', so that work book 'A' will have 30 sheets .

Manually it takes time as I need to copy hundreds of work sheets...

Can you please help me ?

Thanks,
Sesh