I've applied this to a project of mine and it works great.
http://www.excelforum.com/showthread.php?t=474588

Although with my project I have a workbook with over 250 sheets :-)

Is their a way to limit the amount of sheets displayed in the drop down box?

also if the above is possible...

Is their a way to have different set of sheets displayed for each worksheet?

For example, on "sheet 1", the drop down only displays sheets 2-5. Upon the users arrival to sheet 4, the drop down menu displays sheets 30-50.

Thanks for the help in advance.