Compile data from several worksheets to one.

Dear MarvinP,

I have attached the sample spreadhseet with three sheets. What I meant by 100's of worksheets is like the sheets of the same spreadsheets (i.e single *.xls).

Here in the file, there are 4 columns of data starting from the same point in each of the worksheets but they necessarily don't end on the same row. So what I want is on the new sheet to list all the data continuously. I hope you understand. Thanks in advance.