It looks a bit of a mess.
This light has no permenent live available, the supply to your loft lights should therefor have been sourced elsewhere where a permenent live was available.
Can you take some pics of the inside of other upstairs lights, and we can then tell you which to use.
Rather than send the photos to me, just post them here yourself. I am not going to be online all the time

Others can then still read your posts and this thread and help and advise (thats the great thing about a forum)

.
I am guessing the disconnected blue is from the new cable your hubby installed?