Macro to copy and paste or maybe lookup fx?

[go4cdt]

I have been helped in other forums, but I am still desperate for more help. Any help will be highly appreciated.
It may hard to see my problem without picture so I am attching an example file:
* Sheet1: Data is updated and varied from time to time
* Sheet3: reference or data to be looked up
A macro, I am thinking is: if sheet1!B3=1, macro will look into Sheet3 and find the retangle shape in cell B2 (Sheet3), then copy this cell and paste into Sheet2!B3. Sheet2 is what I am looking for as a result.
My thinking is for just a very beginner and I am sure as I have seen in this Excelforum, there are ton of ideas and amazing stuffs and my problem can be resloved in any other incredible ways.
Thanks for your help