Sam

To sum a cell from Sheet1,2,3,....Sheet10

=Sum(Sheet1:Shee10!$I$34)

If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

i have multiple worksheets. i want to sum the cell $I$34 from each workbook
into a single cell in a collation worksheet. is there any way i can use
indirect with a wild card?

sam