How do I merge/combine different workbooks with different sheets
 

I have several workbooks each with one worksheet. These worksheets are all
named something different. I want to combine/merge these workbooks into one
workbook containing all the single sheets. I can't use the "share and merge"
because these workbooks were created separtely and not copied from one
workbook. I have over a 100 workbooks with 1 sheet per and do not want to
copy and past each one.

How do I merge/combine different workbooks with different sheets
 

See this page for a example Steve
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve Descharme" <Steve wrote in message
...
I have several workbooks each with one worksheet. These worksheets are all
named something different. I want to combine/merge these workbooks into one
workbook containing all the single sheets. I can't use the "share and merge"
because these workbooks were created separtely and not copied from one
workbook. I have over a 100 workbooks with 1 sheet per and do not want to
copy and past each one.

How do I merge/combine different workbooks with different shee
 

Thanks Ron - That worked great!!

"Ron de Bruin" wrote:

See this page for a example Steve
http://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve Descharme" <Steve wrote in message
...
I have several workbooks each with one worksheet. These worksheets are all
named something different. I want to combine/merge these workbooks into one
workbook containing all the single sheets. I can't use the "share and merge"
because these workbooks were created separtely and not copied from one
workbook. I have over a 100 workbooks with 1 sheet per and do not want to
copy and past each one.