Create a Report that Includes Newly Added Sheets Automatically?


Is there a way to have a report built off of ALL sheets in a workspace - so that when a new sheet is added, it will be included as well without manual manipulation?

Here is the use case: We have a project checklist that includes a expiration deadline date in each summary. All new projects added will have anew folder created with the same sheet and expiration date.

I want a report that will pull all sheets in each folder of the workspace and pull the expiration deadline. So if a new project folder and sheet is added it will automatically be added to the sheet?

Is this doable?