How to link different worksheets into the 1 menu on a septerate sh

[cregs]

Hi

I need to create 1 worksheet that will have command buttons that will allow
the user to click on these buttons, however these buttons will link to
different worksheets ie top clients worksheet and top callers worksheet, etc,
is it possible to do this without putting all the sheets in 1 main worksheet?

any help would be appreciated

thanks

 

[Luke M]

Yes. You can either use a button to open the file you desire (record a macro
of you doing said act, then assign macro to button) or you could just create
a hyperlink, which does the same thing.