Report from multiple sheets - but automatically including new sheets

Christina Reid

We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each WorkSpace (so across sheets), but also have it add new sheets as new Workspaces are created. Is that possible given the sheets will all be named the same or is the system not "smart" enough to automatically add new sheets?

Paul Newcome

The only way to have new sheets added to a report as they are created is to have all of those sheets in the same workspace and then select the workspace as the source for your report.

Would it be possible for you to create new folders inside of the same workspace instead of multiple workspaces?