how to use input formula from several worksheets in excel?
 

I am working from 13 worksheets in excel. the 13th worksheet needs to have a
formula which uses the numbers from the other 12 worksheets. i do not know
which one i could use? Can anyone help.

If the sheets are all in the same format and you want to sum cell A1
from each sheet then maybe:

=SUM(Sheet1:Sheet12!A1)

Mona wrote:
I am working from 13 worksheets in excel. the 13th worksheet needs to have a
formula which uses the numbers from the other 12 worksheets. i do not know
which one i could use? Can anyone help.