Either you need to go for an excel macro....

OR

from command line copy the .csvs to a single file and open in Excel.
copy *.csv test.txt/b


If this post helps click Yes
---------------
Jacob Skaria


"JDF" wrote:

A data application saves numerical results as Excel .csv files into different
Windows folders (as sub-folders within a main folder) every time that it
runs. I need to be able to sequentially bring selected .csv files into a
single Excel 2007 reporting template that I am setting up to analyze the
data. What is the best way to do this? Thanks in advance.
--
JDF