Dashboard creation

Welcome to the Board!

You have several options on this front.

Create a UserForm that is called in a Workbook_Open event and use Option Buttons or CommandButtons to select sheets; create a blank worksheet with Forms or Control Toolbox buttons which allow users to select a sheets, etc.

There are a lot of ways to go, so can you specify what you're trying to do? I.E. Will you have a static number of sheets, or do you need to create an "on-the-fly" list of sheets from which to select?

Everyone else can take it from there!

Hope that helps,

Smitty

Basically i am reporting to the management capacity performances of different regions. So i will be having performance charts & tables in all sheets. i will be creating multiple sheets and want to link it to the front sheet. When opening the file, the front sheet containing different region names should appear and upon clicking the hotspot it should take it to next sheet. If i am correct i will be having static sheets to be attached.
Hope this clearly specifies my requirement.
Regards,
Madhan

The formula function =HYPERLINK()
may be a start for you
Polly