title: Excel - create sync workbooks to master spreadsheet?
body: <p>Need help. 
  I have over 20 different excel sheets with macro enabled . </p>
  
  <p>I need to create master spreadsheet sheet that can handle live data sync from other worksheets. </p>
  
  <p>E.g I need to link 20 columns from each worksheet and output those into master spreadsheet, so if anyone updates one of those spread sheet, it will auto update master spreadsheet as well. </p>
  
  <p>Multiple people will be working at the same time. </p>
  
  <p>Is this something excel can handle on its own or do I need to get another program? - MS Access would create more overhead for me. </p>
  
  <p>Can anyone suggest solution? Program? </p>
  
  <p>Files are located in SharePoint library. </p>