title: Update google "master" spreadsheet when other sheets are updated
body: <p>I have multiple Google spreadsheets with booking data such as booking number, client name, email, booking date etc. The order of these columns is not the same in all sheets. </p>
  
  <p>I would like to update all data from all my "source" sheets in one "master" spreadsheet. Meaning as soon as a new row is added or an existing row is updated, the data will be synced to the master spreadsheet</p>
  
  <p>What would be the best way to achieve that? Javascript or is there some existing Google Sheets addon? </p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1t-X86RIWzf0AfJjAyR0zNvy5heDiCdgIHl-dvOgt0zE/edit?usp=sharing" rel="nofollow noreferrer">Example sheet 1: Fast boat bookings</a></p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1Cn9qgpJqvIXc07V12VSLdlRiNawF9P2qVSVyCZxEGTQ/edit?usp=sharing" rel="nofollow noreferrer">Example sheet 2: Airport transfer bookings</a></p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1bevDGxCoOJpFXXWHb9YUP8Ke8nKu_QDxdTxur-fbo58/edit?usp=sharing" rel="nofollow noreferrer">Master sheet</a></p>
  
  <p>Thanks so much to everyone looking into this! </p>
  
  <p>Most people recommend to use "importrange", but I don't think this works for my use case. </p>
  
  <p>I am also aware that it could be achieved by Zapier, but it would become to costly to pay for so many zaps. I believe there is another solution.</p>
  
  <p>I do not have any code yet to start with :-/</p>
  
  <p>I expect the data in the master sheet to be sorted by submission date and time like this:</p>