Hi Ernest

Try this

See
http://www.rondebruin.nl/copy3.htm

Or create formulas
http://www.rondebruin.nl/summary2.htm

Note: you only have 65536 rows


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


"Ernest Lai" wrote in message ...
If i create say 500 spreadsheets in excel with information in specific
places. Is it possible to run something to pull all this info and do a
summary of the information?

I am guessing excel will struggle with the amount of data so maybe MS Access
would be a better choice? if so would it be possible in access?

and how difficult is this?