Microsoft Excel won’t sort the buttons automatically — it isn’t a dynamic feature. To get the buttons to update the sort order, right-click the slicer and click Refresh.

Create interactive dropdowns, buttons, and tab-based menu systems using shapes and VBA macros to improve navigation and functionality. ... Design STUNNING Excel Interfaces with Merge Shapes.