Merge excel sheets

I need a vba(in a macro enabled excel) that can merge excel sheets (row by row) but the catch is that it should allow me to select the number of excel files to merge in a folder, merge them and than output the result in sheet2. Excels that need to be merged have the data till Column(AWU).

Can anybody help ?