sheet name in formula

[methody]

I have 4 sheets named A B C D and in each sheet the important cell is B6. On a separate sheet I have a data validation cell with a dropdown box with A B C D. On choosing a particular sheet name I want the cell below to become the corresponding value in B6 of the appropriate shheet.

Any help would be appreciated

 

[methody]

thank you very much - got it to work