In my excel workbook the sheet1 is my Dashboard and sheet2, sheet3, etc...
are graphs , pivots etc...

Actually i need my Sheet1 Dashboard to display Month:Date:Time:Seconds in a
cell, so that whenever i open it should view me and the seconds should be
moving(running)just like a watch....