Hi LP

If your code is working fine and you just want to check the active
sheet you could add the If statement below into your macro, it will
check if the activesheet is "Current Month Sales" and if so it will
change it to "MasterLog 2008".

If ActiveSheet.Name = "Current Month Sales" Then

Sheets("MasterLog 2008").Activate

End If

i hope this helps

Steve