I know it sounds like a terrible idea,but next time you wait for the tab to restart how about looking into the sheets api docs? And the next time,try to write a quick script that just makes updating the cells you need to update a bit easier. At the end of it,at least you won't have to suffer.
+1 for Google Apps Script. I’ve built dashboards in sheets using Apps Script to call web services. I think you can even make your Apps Script act as a rudimentary FAAS using the sheet as a database.
