Check out Ron de Bruin's site:

http://www.rondebruin.nl/tips.htm

Specifically, his article on merging multiple workbooks:
http://msdn.microsoft.com/en-us/library/cc837974.aspx
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eva" wrote:

Hi
I have number of workbooks in C:\My Documents and I would like to copy
sheet1 from all of them and paste it into new book. Is there a macro to do it?

--
Greatly appreciated
Eva