Excel 2007 : combine data from multiple workbooks to a single new worksheet

[ame]

I have the following folder structure (Please see attached 'sample'), workbooks 1 to 5, each have 1 worksheet in it and all have the same 10 columns. I want the rows from all 5 sheets to be combined and displayed in the MASTER workbook. Please advise a macro to enable this functionality.

i.e: A user goes into 1 and adds a row, saves and closes. Then users adds a row in 2, saves and closes. The master should show both these rows. (same as a UNION query in access)