Check this out, Don. It should be exactly what you need.
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"DonB" wrote in message
...
I have a workbook of several daily reports. There is a summary sheet that
I
wish to reference the last daily report even when I add one on. Is there
a
"Last Sheet" function I can use?
--
Curious