Hi and thanks in advance.

I created a button that drops down a list of most of my sheets in the workbook but the list is truncated and only shows 14 of my sheets in the list. I then have to select more sheets to pull up a small scroll window to find the one i need to jump to. How can i create a full scrolling list of sheets and or make the list searchable? I dont know if this would be better done using a drop down menu or a clickable button. Im not advanced in excel so any step by step help is appreciated.