closed files
 

i've created 100's of stock files (ibm.xls, aapl.xls, etc) that are
format/layout identical. the column headings are
"Symbol" "Name" "Price" "Date". the next-to-the-last row is
"GM" "General Motors" "14.56" "9/23/2005", the last row is
"GM" "General Motors" "12.34" "9/30/2005", for example. i'm trying to
gather the last row of data from these 100's of CLOSED files into a
single file with the same headings as mentioned.
any ideas would be appreciated.