Collecting data across multiple sheets to one sheet.

Hi There,

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?