How do you pull information from the selected sheet when building a project using Control Center
Here is the situation: We have setup Control Center to build a project workspace from sheets. There are also several dashboards and a separate summary sheet. We are pulling information from the separate summary sheet into the dashboard. A number of other sheets (currently 5 but this will grow) have been identified as a group so that you can only select one during the Control Center build. This information is currently listed in the sheet summary
Here is what I need: We need to get data into the separate summary sheet automatically from the remaining sheet (selected during the Control Center build process)
Optional Need: Can we pull directly into the Dashboard using the widget using the selected sheet information?