You can go to File --> Spreadsheet Settings --> Calculation --> Recalculation, and choose “On change and every minute”. This will make the entire sheet update itself every minute.
You can go to File --> Spreadsheet Settings --> Calculation --> Recalculation, and choose “On change and every minute”. This will make the entire sheet update itself every minute.