Hi
I need a small VB Script.

I have Sheets names "Store1", "Store2" & "Store3". Also I have another sheet called "DATA"
I need to run a macro while I am in Any of the Store1, store2 or store 3.
What I need is to copy the data of Colum-B of my active row and paste it in "DATA!B5" cell.

Eg1: If I am in any of the cell in Row 11(eg.store1!K11) and when I run the macro, then it should copy Store!B11 data and paste it in "DATA!B5"
Eg2: I am in Store2!S15. When I run the macro it should copy Store2!B15 and paste it in "DATA!B5"

Hope it is clear
Thanks a lot
Tom