Method to continuously append multiple sheets into one sheet



I'm looking for a method append multiple sheets into one sheet. I have multiple projects, each with their own sheet. All sheets have the same column names. I can use a report to combine the sheets together and group by sheet name, but I need to do additional manipulation of the data once combined. Is there a way to combine multiple sheets into a new sheet rather than a report? The sheet would need to automatically update, like a report. I've seen some external add-ons with this capability but is there an internal smartsheet solution?

I'd also like to create charts based on the combined sheet data but I don't think that is possible if the data is in a report.