Hi,

Yes that should be doable. From a process point of view is this how you expect the process to work.

1. The daily log is opened and VBA records the date, time and the row number of the last entry as VBA variables
2. Entries are added to the log.
3. 4 hours after the time recorded in the VBA variable, all the records after the row number are Moved and added to a separate master workbook
4. The VBA variables are reset
5. Steps 2-4 repeated..........

Questions.
1. You say moved. Does that mean the records will be deleted from the log immediately the move has taken place? Or do you mean Copied?
2. If you mean copied what is there to stop the dispatcher sorting the log and compromising the records transferred at the next 4 hour event?
3. The VBA code will need to contain the password needed to open the Master workbook. The VB environment can be protected so that a password to get into the VB code would be necessary in order to discover the Master workbook password. But given that, wouldn't it be easier to have a password protected sheet in the log workbook that the dispatcher couldn't unhide or see?