How to create formula for cell Value from cell in other sheet by input row Number ?

[SomchaiSomjui2011]

I want user only in put row number to start to Calculate data -> How to create formula for cell Value from cell in other sheet by input only row Number ?

Sheet A : Have data in many rows

Row      A              B             C           D          E

1          XXX          7

2         DDD         3.5

3         BBB           2

4          JJJ             1.33

            ...

            ...

            ...

at Sheet B : Want user in put only Row number to be Value from row sheet A 

For user

Sheet =      A

Row =        xx <- User  Input only row number  to Start for sum

At sheet B

cell C10 =SUM(C11:C999)

cell C11 Start Value 

at cell C11 Start Value from Sheet A

=A!Bxx                 <- How to create formulas or Function like this requirement ?

=A!B(row xx+1)    <- How to create formulas or Function like this requirement ?

=A!B(row xx+2)

=A!B(row xx+3)

   ...

   ...

   ...

Thank you very much

:)

[#2 · Accepted solution]

@SomchaiSomjui2011 

=SUM(INDIRECT("'"&C1&"'!"&"C"&D1&":"&"C"&E1))

Is this what you are looking for? In sheet A you can dynamically enter the row number in cells D1 and E1. 

[#3]

Yes Thank you very much -> I can do it now by change some formula like this
'=INDIRECT($D$1&"!"&"B"&$D$2)
$D$1 = Sheet A
B = Column B
D2 = Start row

and next row i change Formula to
'=INDIRECT($D$1&"!"&"B"&$D$2+B12) -> for Copy to 999 row
B12 = Column B row 12 i'm runing 1 , 2 , 3 , 4, to next row
Now i can do it
Thank you very much :)
:)