How to switch to different tab in same workbook using VB code

Hi,

I am creating a excel sheet in which I have added a VB form which populate some values from the excel sheet.

What I want is that when I select "type number" from combo box and click on "view type number status" , I should automatically comes in that work sheet.

fo ex.
I select IR from "show All type" and corresponding values populated in "select one type number" , let it be 1. Then I should automatically comes to work sheet with name "1".

I have attached the excel on which I am working.

Can any body tell me the solution.

Thanks