Yes, list you worksheet names in any Column and use INDIRECT.



--
Regards
Dave Hawley
www.ozgrid.com
"ferne" wrote in message
...
I have a yearly summary worksheet by week. Each week i add the weekly
report
to the workbook. I need a formula on the summary sheet that will change
the
worksheet name when I copy it down. Is there any way to do this? Would
send
a copy of my workbook but nowhere to attach it.
--
ferne