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
<tbody>
</tbody>
Below is the structure of my sheet.
Link to sheet: http://1drv.ms/1Okx7Hl
Sr No | Date | Inquiry Time | Customer Name | Mobile No | Nationality | City | V/ Make/Model | V/ Reg No | VIN No | Product/Service Type | Invoice No | Total Invoice Amount | Incharge Name | Branch Name | Sales Status | Remarks |
<tbody>
</tbody>