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