Using same combobox with macros across multiple sheets

I have been trying to get a combobox that has 5 items and each with a macro that will redirect to another tab to work across each of the sheets across the workbook. I originally followed the advice of this threat http://www.excelforum.com/excel-programming/654789-how-to-activate-a-macro-from-combo-box-list-box.html but after getting the first sheet's to work I tried to keep the same setup making sure that each combobox had the needed code.

I keep getting pointed to the Application.Run line of

Please Login or Register  to view this content.

Is there something wrong with the location of my macros being in the wrong place? ie the wrong module or throughout the entire workbook? Any help is appreciated

I used the workbook example from the link i posted in OP. This modified version works however my actual workbook isnt liking this...