A spreadsheet dashboard is a table of all the data that's been entered into the computer with the spreadsheet application. The table is often created and designed as a static table, which allows you to drag and drop from the various rows and columns, but if you want a dashboard to be more dynamic, you will need to create a table as a table on a template. Here is how you can do it.
db-excel.com
Excel Spreadsheet Template