Cross-Sheet Project Status Rollup (Dashboard?)

edited 12/09/19 in Smartsheet Basics

Long time user, first time trying to do something cross-sheet.

Lets say I have a folder called "Projects" and it contains all "Project Sheet" type sheets.  Outside of the folder I'd like to have a sheet or a dashboard that dynamically looks at the sheets inside the folder, list out the sheet names with total % complete.

Any advice on where to get started?  Is that a dashboard?