Select worksheet based on condition & populate cell based on condition

We have the following worksheets with corresponding tables:

-------------------------------------------
WorksheetName1 = TennisBalls

Table in this worksheet

Ball_Color Selection
======= =======
Cell A B

1 blue -
2 red -
3 green -

-----------------------------------------------

WorkSheetName2 = BasketBalls

Table in this worksheet

Ball_Color Selection
======= =======
Cell A B

1 blue -
2 red -
3 green -

----------------------------------------------------

WorkSheetName3 = SoccerBalls

Table in this worksheet

Ball_Color Selection
======= =======
Cell A B

1 blue -
2 red -
3 green -
-------------------------------------------------------

WorkSheetName0 = Main

if( (condition1 == SoccerBalls) && (condition2 = = red)

then
SoccerBalls!B2 = Yes

--------------------------------------------------------

I am checking for conditions in the Main worksheet. Based on the Then clause, I want to jump to the corresponding worksheet and populate the corresponding cell.

(1) How do I set up the Then clause in excel?

(2) Is it possible to set up the Then clause where it is table-driven? In reality, I will have:
10 worksheets x 30 colors = 300 combinations

Thank you for your expertise and time!

Are the cells color coded or are the colors typed in?