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