Hi sorry for being vague but I'm very new to excel and needs some help.

Question:
I uses two sheets: i.e. "pay" and "latter"
I want the value of 'pay!A1' to refer to the cell 'latter!A(pay!A1)'

so that I can use a formula in cell pay!C1 that is something like this:
=SUM(B1 * latter!A(value of pay!A1)

hope you can understand my question :)

regards
Morten T