//please make sure the exact path of your files
string fns, path$ = system.path.program$ + "\samples\curve fitting\"; 
//you can change the extension of file to txt, csv and so on
findfiles fname:=fns$  ext:="test*.dat"; 
impasc fname:=fns$
options.ImpMode:=4 //start new sheets 

//loop over all the worksheets and copy column#4 of each worksheet to a new worksheet named summary
doc -e LB {colcopy irng:=Col(4) orng:=summary!Col(ii)}; 
wks.nCols = wks.nCols-1; //delete the last column 

wks.deleteRows(1,5);