Is it possible to create an aggregate worksheet based on grand totals from 3 separate worksheets as you can in Excel? Does Tableau work like that? Also how do you resize the sheets (tabular view) to fit the dashboard?
Tableau does not allow you to use the results of one worksheet as input for another worksheet . Depending upon what you are trying to accomplish this can be done with table calculations. If you post a workbook I can help you with this.