You would need to install an add in or in each workbook workbook_close event add some code to open the destination workbook and add the data something like:
[VBA]
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks.Open ("C:\Test\Log sheet.xls")
ActiveWorkbook.Sheets("Sheet1").Range("D" & Rows.Count).End(xlUp).Offset(1, 0).Value = Time
ActiveWorkbook.Close (True)
End Sub
Private Sub Workbook_Open()
Dim Rng As Range
Workbooks.Open ("C:\Test\Log sheet.xls")
Set Rng = ActiveWorkbook.Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp)
With Rng.Offset(1, 0)
.Value = Environ("username")
.Offset(0, 1).Value = Date
.Offset(0, 2).Value = Time
End With
ActiveWorkbook.Close (True)
End Sub
[/VBA]you can work out the additional information and how to save from there!