Hi

Go to Ron de Bruin's site for sample code to show you how to merge data from
many files.
http://www.rondebruin.nl/tips.htm

--
Regards
Roger Govier

"LG" wrote in message
...
I have a year worth of data in at least 8 folders. Each folder contains
at
least 10 files with in each doc there maybe up to 20 tabs of data. They
all
have the same heading. Can I get a step by step way to merge this into 1
tangible document that can be read for an end of year type of doc for
research purposes?