See Ron de Bruin's site

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

He has sample code on many aspects of this

--
Regards,
Tom Ogilvy


"Daniel" wrote in message
...
Hello, I have seen a small piece of code many years ago that would
consolidate many sheets. I lost it. I have code that will read each
cells
but now that my sheets will contain the same format, that is same piece of
information in the same cells, I am looking for a fast consolidation.
Could
someone suggest something.

Thank you

Daniel