I am trying to have a column where there are a few letters and then
essentially the date. The problem I am having is that it needs to
automatically update with the prior sheet, so if that sheet was updated on
8/22/07 I need my cell in a different sheet to say something like PEL082207.

Does anyone have any ideas?

Thank you,
Katie