Activate worksheet based on a column value selected from validation list

In the column cells within the B5:B45 range, I am able to click on a validation data listing of the following values: Father, Mother, Son. I have other worksheets created on the same workbook, which have separate forms written for each of the B-column cells. For example, the cell B6 has three separate worksheets (one for Father, one for Mother, one for Son) already written for it and ready to be activated depending on which of the three values is selected. Each B-column cell in this range also has a macro button located in the same row, which I will click on to activate the worksheet corresponding to the value.

Please Login or Register  to view this content.

The above macro will take me to the Father9 worksheet if I click on the button. However, I would like for a macro be created that will correctly direct me to one of three worksheets listed above when I click on it. Is it possible to write a conditional macro to also include the "Worksheets("Mother9").Activate" and "Worksheets("Son9").Activate" in it?

Any help will be greatly appreciated!

I just figured out the following macro, which enables me to activate the correct worksheet based on the value entered in the B5 excel cell.

Please Login or Register  to view this content.

The problem, however, is that I have a column range of B5:B45. This means I must duplicate 39 more macros for cells B6 through B45, in addition to the creation of 117 more worksheets on the same workbook.

Is there a single macro that can perform within this B5:B45 range and be able to automatically copy the corresponding RefRev5 or Trie5 worksheets whenever a new entry is made in the B-column cells? I am afraid that having so many worksheets on this workbook will slow things way down. Sure would be awesome if someone can help create this macro!