Hmm,

If the counters get reset at 5.00am would it not be prudent to do the
print outs a minute earlier to avoid running head on into that process.

Charlotte, I feel this would require activation of the OnTime Event.

I use the following to Enable/Disable an AutoSave feature...

Option Explicit
Public RunTime

Sub StartTimer()

RunTime = TimeValue("04:59:00")
Application.OnTime RunTime, "Print_At_Five", schedule:=True

End Sub

Sub Print_At_Five()

Dim my1stSht as worksheet, my2ndSht as worksheet

Set my1stSht = Sheets("Your 1st Sheet")
Set my2ndSht = Sheets("Your 2nd Sheet")

my1stSht.PrintOut
my2ndSht.PrintOut


End Sub

Create a Macro button on your main sheet somewhere out of the way and
"Assign Macro" ( StartTimer ) to the button and click to activate.

HTH
Mick.