Excel formula to pull data from external worksheets

[soorajj]

I have a master sheet containing customer data from 10 different spreadsheet saved in network folder for 10 outlets, all those sheets are same structure, now i am looking for excel formula to sync data from all 10 sheets to my master sheet, when ever i open the master sheet the data needs to be synchronized and updated. Any help?

Below is the structure of my sheet.

Link to sheet: http://1drv.ms/1Okx7Hl

[TABLE="width: 2530"]
<tbody>[TR]
[TD="class: xl65, width: 46"]Sr No[/TD]
[TD="class: xl63, width: 81"]Date[/TD]
[TD="class: xl63, width: 121"]Inquiry Time[/TD]
[TD="class: xl63, width: 188"]Customer Name[/TD]
[TD="class: xl63, width: 104"]Mobile No[/TD]
[TD="class: xl63, width: 102"]Nationality[/TD]
[TD="class: xl63, width: 84"]City[/TD]
[TD="class: xl66, width: 141"]V/ Make/Model[/TD]
[TD="class: xl65, width: 121"]V/ Reg No[/TD]
[TD="class: xl63, width: 149"]VIN No[/TD]
[TD="class: xl66, width: 202"]Product/Service Type[/TD]
[TD="class: xl66, width: 75"]Invoice No[/TD]
[TD="class: xl66, width: 80"]Total Invoice Amount[/TD]
[TD="class: xl63, width: 140"]Incharge Name[/TD]
[TD="class: xl63, width: 127"]Branch Name[/TD]
[TD="class: xl63, width: 161"]Sales Status[/TD]
[TD="class: xl66, width: 608"]Remarks[/TD]
[/TR]
</tbody>[/TABLE]