Metric sheet that feeds dashboards

Hello,

I am looking for best practices for setting up a metric sheet to feed a dashboard.  I haven't found anything in help.  I've set up sheets with my formulas to pull data from various sheets and then use that data for graphs, reports for dashboards.  I've caused myself problems while sorting and wondered if there is anything to help set up those sheets.  Thank you.