I have following formula in worksheet(RDRead)cell D2, which retrieves data from another worksheet(RD) and some controller reference from active sheet RDRead only.
=VALUE(SUBSTITUTE(SUBSTITUTE(MID(RD!$B1,FIND($D$1,RD!$B1)+12,(FIND("pChange",RD!B1)-(FIND($D$1,RD!$B1)+12))),",",""),"""",""))...