Automatically Combining data from multiple excel files in a folder onto one file using VBA

I will have certain number of data dumps( say 10 excel files) in a folder. Need to combine all files into single excel file with single click of a button. All files will have similar data columns.