Using a cell value on the current worksheet in a formula referencing another workshee

I am trying to write a formula that will add cells from multiple worksheets in the same workbook. I am using the formula "='1'!S9+'2'!S9+'3'!S9+'4'!S9+'5'!S9+'6'!S9+'7'!S9. I want to modify this formula so that it will reference the worksheet page from another cell in the same worksheet. IE: for the formula above, I want to replace the beginning reference to worksheet '1' with the J4 cell from the same worksheet I am writing the formula in. Does anyone know how to structure the formula so that it will take the worksheet reference in a formula from ANOTHER cell value in the same worksheet?

Hi

Try the INDIRECT function

=indirect("'"&j4&"'!S9")+'2'!S9+'3'!S9+'4'!S9+'5'!S9+'6'!S9+'7'!S9

rylo

You are a genius.