Linking spread sheets to a master list

I was asked to combine 7 diffrent spreadsheets into one Master list. Seems simple enough, though there are specific actions that I need the Master list to do, that I just cannot figure out. what needs to happen is, if someone updates or Adds a new row of information into their spreadsheet, I need the Master list when opened to automatically update the new information, and/or Add in the new Row. ie. If I have 7 sheets with 10 Rows, each 1-10, I should have a total of 70 rows, and if someone adds a new row to their sheet, I will now have 71 rows showing, or if two people add 2 Rows of new information each, than it would re populate the list to show 74 Rows.

Is this possible? is there a way, to have excel distinguish when someone enters information into a blank row in a separate spreadsheet and automatically insert it into the Master list? and have the Master List distinguish that each spreadsheet has different information on the same Row, but still shows each different Row, and each new added Row from the sub spreadsheets on it?

Spsht 1 Row 1
Spsht 2 Row 1
Spsht 3 Row 1
Spsht 1 Row 2
Spsht 2 Row 2etc...

I hope this makes some sort of sense. Please help, anyone... if you can. It is greatly appreciated. Even if its as simple as a No, it cannot be done.