how to import external excel files data into a single sheet

[diga]

I am looking for a way to import data from multiple worksheet into a single sheet of a new excel file.
More info: All worksheets are stored in the same folder. All worksheets have same column headers but varying number of rows.

Thanks.

[patel45]

http://www.rondebruin.nl/win/s3/win008.htm

[diga]

http://www.rondebruin.nl/win/s3/win008.htm

Thanks patel45.
I have one more question.
When I run macro a new worksheet get created and all data get imported into sheet 1 of that new worksheet. But I want data to be imported in the same worksheetof macro but in sheet 2.
Could you plz suggest some changes that I have to do in VBA code.