Combine multiple workbooks automatically

Hello,

I need to be able to combine multiple workbooks with varying titles automatically. the content within these workbooks is identical however i would like to be able to pull all the data into one master spreadsheet. Once i have brought over row 1, which contains the column headers, i would want to omit row 1 from populating from the rest of the workbooks. any ideas???

Thanks in advance for anyone willing to help.