See
http://www.rondebruin.nl/merge.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"outrigger" wrote in message ...
I am using excel 2003. I have a report workbook that has 27 other workbooks
that it gets information from. What is the easiest way to update the report
workbook with out me singularily opening each of the 27 other work books.
The are all under the same folder on the same drive. including the report
workbook.