One option would be to put the desired worksheets in a workbook together before publishing. This can be done using bookmarks:
Hope this helps!
I tried this approach and it has worked. Thank you very much for your great help.
I had one more question which related to this.
I have publish the tabbed dashboard like :
Global | NA Region | SA Region | EU Region | Asia Region
Now if I want to give various user groups access to these tabs.
For example :
1. Global user group can access all the Tabs
2. NA Region user group can only access NA Region Tab.
3. SA Region user group can only access SA Region Tab.
4. EU Region user group can only access EU Region Tab.
5. Asia Region user group can only access Asia Region Tab.
Note I am using active directory groups for this.
Is this achievable ? if yes, could you please provide me some pointers how can I do so.