combine data from multiple workbooks to a single new worksheet

Hi,
Very new to Macros, thankful to anyone who could help,

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)

Thanks