i want to write a formula, not vb, using a value in a cell to reference
that sheet name.

on a summary sheet i list the names in column b4, Kim in this example.

in column c4, this formula would give me the value i need from kim's sheet,
=Kim!$E$32

so if i have Kim entered in column B, what would the formula be to use the
name in B4 in the formula ?

tried a few options like =B4 & "!$E$32, = indirect(b4)!$E$32 but nothing
worked


--


Gary