I’m looking to have many duplicate sheets collecting data for different sites that we work on. But then, when it comes to reporting, I need a sheet that has collected all the information across the other sheets to build a report.
For instance we have site A, Site B Site C etc… All the info in those sites need to be separate for inputting data and ease of use. But then I’d like a sheet ‘All Sites’ which has captured the data across Site A, B and C…
Not sure if this is something the system can do?