Consolidate Metrics from multiple existing and new sheets
We currently have multiple workspaces for each individual job that we do. Each job will have its own Metrics sheet that brings data from the other sheets for progress. As new jobs come in, new workspaces are created.
I am looking for a way to be able to create a high level Metrics sheet that can look at all the individual Metric sheets on each job.
I can certainly create one and manually link the data but I'm looking for a way that I can create a more automated one where it can look at existing ones and as well as everytime a new job is created.
I know this might be a long shot but is worth a try.
Thanks for your help