I will try to send you in the right direction because I don't have time to actually fix all the code. But here is your problem.
Your sheet with the comboboxes has a series of Subs that handle changes in each of the comboboxes, like this
The whole concept of using a single FollowLink sub to manage everything doesn't work in this case (there are cases where it can work but this requires a little more complexity in the code). FollowLink gets the index from whatever combobox changed, but nothing in FollowLink knows which combobox changed. The actions you take are very specific to which combobox changes, so there is absolutely no advantage to lumping all of these actions together into a single Sub.
I would eliminate FollowLink and simply put the appropriate code into each ComboBoxx_Change Sub. Like this. Then you no longer have to determine which sheet is active, etc.
Your EnableEvents call doesn't affect combobox events, only worksheet events. I've shown a change to cover that.
Bookmarks