In a Worbook if you have an item in cell A1 and have all the items in the "A" column available as a drop-down box on another sheet can you create a rule to say anytime the contents from cell A1 on sheet one is selected in another sheet then the contents from cell B2 on sheet 1 will automaticlly be placed in the cell to the right of it?

Example Example
Sheet 1 Sheet 2

Cell A1=Cat B2=Dog Cell A1 from Drop down is Monkey B2 would = lion
Cell A2=Mouse B2= Bird
Cell A3 = Monkey B2= Lion

All contents from Sheet 1 in column A would be available as a drop-down box in the other sheets. If anywhere in other sheets A1 is chosen then whatever is in the immediate cell to the right of it in sheet 1 would follow it in the new sheet?

Sorry if I am not making sense. Any help is greatly appreciated!