There is nothing to do with Dashboard, Except if you have data is Aggregated.
For Instance, If your Sheet 1 to 3 has detail View with Different Measure and so forth.
In the final page, Your giving aggregating Profit or Loss in the Bar or what ever.
Final sheet is reflect based on your data or You can create a Calculated fields and You can do some maths which ever you want to.
If you want some specify req, Please share your Idea with Details allong with TWDX file that way, Community Team can able to help you.