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