soliciting help for creating a dashboard


I am tasked with creating a dashboard that pulls data from 5 different sheets. i was wondering if there are services with Smartsheet, where they help with organizing that data so you can create a dashboard.

I actually have a template (internally created) that i want to replicate but im confused as how to organize and the formulas needed.