Yes, That is possible.
You need to give sheet conditions for every sheet.
You can also give Calculation condition for the charts so that only when the sheet or chart is active it will calculate.
Give a trigger which one selection while opening dashboard.
By this you can reduce the dashboard load time.