Try this page
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"helphelp" wrote in message ...
Hi, I have about 200 excel files for different companies that contain the
same financial data. Eg: sales, net income etc. The companies are classified
into 4 categories A, B C and D. I want to create a report in a new worksheet
that gets me the sales data for all the Catgory A companies etc. Please tell
me what is the best way to do this. All help is appreciated.

Thanks.