Yes. Take a look at INDIRECT in help.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JDR" wrote in message
...
I am trying to summarize my data on the last sheet of the workbook.... the
sheet names will change frequently..... so what I am trying to do is have
a
cell (column header or name) on the summary sheet automatically read the
name
on each sheet and use it in the cell for my header-- Then when the sheet
name changes it will automatically update my summary page... Is this
possible?
Thanks