Can you give us a few more details?

What "update" are you referring to?
€¢Do all the sheets have the same structure?
€¢Is there a single cell with a value that changed?
€¢Are you copying a range from each sheet?
€¢Do you skip sheets that did not change?
€¢Are you comparing sheet values against a master sheet to detect changes?
€¢Do the sheets use Named Ranges for the data you're interested in?

***********
Regards,
Ron

XL2002, WinXP


"Eric" wrote:

I get 10 excel files, 1.xls, 2.xls, 3.xls, ... 10.xls, summary.xls
I need to open each file, get update and close it in ascending order.
Does anyone have any suggestions to performance this tasks automatically
through one action? if not, I have to update each file manually, which takes
me 30 minutes to do that. Does anyone have any suggestions?
Thank you in advance
Eric