Hi tcgaines

Try
http://www.rondebruin.nl/copy3.htm

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


"tcgaines" wrote in message
...

II have 5 Workbooks. Each have one worksheet. I want to create a new
workbook that includes each of the worksheets from each of the five
workbooks. how do i do that? One problem I forsee is that each of the
worksheets are named "Sheet 1" by default.

thoughts? thanks.


--
tcgaines
------------------------------------------------------------------------
tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608
View this thread: http://www.excelforum.com/showthread...hreadid=493857