Tell CopperRiver which sheets to merge. It does it every morning before you start.
Every morning you open 5 different Google Sheets — sales, support, marketing, product, and finance. You copy the relevant data from each one into a master sheet where you can see the full picture. It's the same columns, the same format, every single day. And if you miss a day, the master sheet is useless.
Every morning at 8am, pull data from these 5 Google Sheets and merge them into a master sheet. Use the same column structure as last time. Save it as Master-Dashboard-[date].
4 steps
Done. Your file is ready.