see the gif.
in it i present the app, original CRM file, Copy of the CRM file which all its sheets are importrange from the original and a demo dashboard I built with Google Sites.
in the scenario, I add 1 customer to the app while all files are close and show how the demo dashboard which is connected to the copy CRM file is being updated instantly.
