Iâve been working with a number of scripts on pulling and pushing data between spreadsheets, but I am looking for something lightweight for creating dashboards of many different spreadsheets. I would simply use Importrange, but it is too unreliable and I canât have dependent importranges (meaning, a dashboard of other dashboards).
Does anyone know of a lightweight script I could use to approximate importrange wherever I needed it in the sheet and then use a menu option to ârefreshâ the data?
Thank you for any help you might be able to provide.
