Please first create a new workbook and make sure its name as Book2. Then try the following scripts to move all the rows of 250 worksheets in Book1 to Sheet1 of Book2. Please note that I just directly move the data into Book2, which means you need to perform some subsequent operations to get what you want, such as set the sampling interval etc (also could be done with scripts).
int maxrow =1;
range aa = [book2]1!;
for(ii=1; ii<=250; ii++)
{
wrcopy iw:=[book1]$(ii)! dr1:=$(maxrow) ow:=[Book2]1;
maxrow = aa.maxrows+1;
}
