Merge selected worksheet from selected workbook into a new workbook and compile

[anshul.vijan]

<TABLE class=tborder id=post2744966 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2744966 style="BORDER-RIGHT: #ffffff 1px solid">Hi Guys,

This is my first post here. I have a common issue but i am facing trouble customizing it. In my scenario I have many employee workbooks with 'similar' names for example: SDA 1, SDA 2, SDA 3.... They all have the standard three worksheets with names 'Sheet1' ; 'Sheet2'; 'Sheet3' and only 'Sheet1' from all the workbooks have relevant data in it. The header row and column formatting for all the 'Sheet1's in all the workboks is the same and they are located in the same folder.

I have another workbook bythe name of 'Master.xls' which contains the same header row and column as the 'Sheet1' from the above mentioned employee workbooks (SDA 1, SDA 2...).

Can anybody help me with a macro that will combine all rows with data excluding the header row from all the employee workbooks (only Sheet 1) into the Master.xls workbook's Sheet 1 which already has a header row .

I would like it to give me an 'open file' dialog box so i can select which workbooks do i want to include in the process of combine and compile.

So, basically all employee data combined and compiled one under the other wih no header rows.

Thank you so much in advance.
<!-- / message -->
</TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">

</TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls --></TD></TR></TBODY></TABLE>