Combine multiple spreadsheet into a master listing spreadsheet

1. How can i combine the multiple spreadsheet that is in my excel (which includes 4 of them) into a master list and it will be combined one after another. Meaning after Sheet1 last row will continue with Sheet2 first row and so on.

2. I also wish to have a automatic update in the master list spreadsheet when i make changes in the other spreadsheet.

I've been searching and trying for 2 days >< anyone please help?