I am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in.
I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter.
I created a report to pull names and emails from each of the groups individual sheets.
Now I need to create a sheet that can pull that information from the REPORT specifically, as the report is already filtered to include what I need. The new sheet will contain additional columns where we will need to enter information for each individual to request their credential for specific zones.
Is there a way to pull information from the report, considering that the report is pulling from 66 individual sheets?
