ExcelBanter - View Single Post

Don Guillett

=sourcesheet!a2

--
Don Guillett
SalesAid Software

"crisgrnr" wrote in message
...
In Excel, is there a way to reference a worksheet tab to a cell in a
worksheet? For example, I have a date cell that references to all my other
worksheets so I only have to change it once. I also have to manually
change
that date on one of the tabs for the Summary worksheet. Is there a way to
reference that tab to automatically obtain the date I enter in that one
cell
on the summary sheet that is used to reference all the other sheets? If
not,
can this be created? This would be much easier because people forget about
changing the tab names...but if they could be referenced to a cell, just
as
one cell can be referenced to another...we worldn't have to worry about
changing the tab name or title. Please help..thanks
--
--cris