Sal

My apologies - its difficult to know how to pitch responses.

I'm suggesting that what you need is a macro which is triggered when
you add a date to one of your individual sheets.

This macro will take the current time from the system clock and place a
value on the control sheet. The function to do this is called Now(). You
will find details in the help file.

To trigger the macro, the code needs to be placed on the ThisWorkbook
tab of the VBA editor (Shift F11) and given the name
Workbook_SheetChange so that it runs every time a cell's contents are
changed.

Without knowing the detail of the sheet, its not possible to write the
code here.

I hope that this helps.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=559439