Combine different sheet to one Master file

Hi,

1) i have extract different excel report in one folder now i have to arrange all the extract report data in one sheet with same format and one by one. ex. suppose 1st sheet data end on row 10 then then 2nd data paste just below on that and same for 3rd,4th etc. And i have to copy all the data in that sheet not particular column & rows.

Can anyone help for the above query...

Thanks in advance

Does this help?

http://www.vb-helper.com/howto_excel...sed_range.html

Thanks for reply

But it is not working, i have to not arrange single column or rows i want all the data in sheet copy to master file with same format and other sheet data below on that. I have extracted all report in one folder so the macro will be like that he asked about the folder and choose sheet and arrange data one by one to new excel sheet?

Hope you will understand...

Thanks