So sorry you've been having this trouble. Night sweats are enough to frustrate us without also having to deal with odor.
Have you noticed any pattern to when you notice the smell? Does it only happen when you are having night sweats, or does it happen at any other time?
By chance, do you have diabetes?
Does it seem to happen around the same time in your cycle each month?