Report from multiple sheets - but automatically including new sheets

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?