Hi

Start here if you want a macro solution
http://www.rondebruin.nl/copy3.htm

More
http://www.rondebruin.nl/summary2.htm
http://www.rondebruin.nl/ado.htm


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


"kgsggilbert" wrote in message ...
What is the simplest method to total data from multiple excel files? The data
will have the same worksheet and cell reference in each file. I am trying to
summarize data from over fifty excel files. I am trying to avoid opneing each
file and pasting the cell reference from each file into my summary file.