excel - How can I get the value of a particual cell from all worksheets? -

I have an Excel file with many worksheets, now I have to get SM of all H1 cells in all worksheets. Is this also possible? How can I do this?

You can use a formula like this:
= SUM (sheet) 1: Sheetx! H1)

or in VBA:

  For each W in this workbook. Worksheets H1Sum = H1Sum + w.range ("H1"). Value next