I think this requires VBA. Working Office Excel 2003 on XP. I have two
separate folders; "A" and "B". "A" contains many worksheets, all formatted
the same but with different data (R Squared, Slope, y-Intercept) and
different names (basically a numbercrunching worksheet saved accoring to test
and date performed, i.e. "AML11-28-07", "AML11-29-07" ). Folder "B" contains
a worksheet where the data from each worksheet in "A" is crunched further to
generate Trend logs. 15 "Run's" (each worksheet in "A" is a "Run")at-a-time
are logged into the worksheet in "B." This worksheet calculates the Mean,
Standard Deviation, and %CV for the "Runs" over time.

What I'm trying to do is have the Worksheet in Folder "B" search folder "A"
for new "Runs", take the data I want from particular cells in those "Run's"
in folder "A" and crunch it in groups of 15. PLEASE feel free to contact me
for examples or worksheets.