combinne worksheet from different files

[sierralightfoot]

I have worksheets in 25 different files. I want to combine/merge them into
one worksheet without having to cut and paste each one. How Ultimately I want
a macro
to perform the task each month.

[Norman Jones]

Hi Sierra,

See Ron de Bruin's sample code at:

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


---
Regards,
Norman


"sierralightfoot" <[email protected]> wrote in
message news:[email protected]...
>I have worksheets in 25 different files. I want to combine/merge them into
> one worksheet without having to cut and paste each one. How Ultimately I
> want
> a macro
> to perform the task each month.