=INDIRECT("'"&TEXT(TODAY(),"mmddyy")&"'!L1192")

[Note that you don't need a + in your formula if you are not adding
anything. That looks like a relic from old Lotus spreadsheets.]
--
David Biddulph

"pm" wrote in message
...
We have a daily file with several worksheets....in one of the tabs I link
specific fields to another tab that uses the current date as the name -
=+'022808'!L1192 ......so the tab name changes daily to reflect todays
date.
My question is, how can I link to a tab that has a different name every
day?
Is there a formula that I can use instead of +'031008'!L1192?