Combining multiple excel sheets into one excel file and updating it each time there are changes.

i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the s...