Code not functioning properly

Hi guys,

I have attached a sample wb. User John password test. I seem to have identical codes in sheet 4 & 5 bar a couple of different cell refrences and the code seems to be working fine in sheet 4 & not in sheet 5. The latest code I have introduced was to autocapitalise names so for example if I input jOE blOGgs it would automatically go to Joe Bloggs. This works perfect in sheet 4 but not in sheet 5. I am very new to VBA and don't know it very well so would love some feedback if there is an error or something in it. I do get help from you guys then when I insert it into existing code that's where I sometimes make the mistake.