Hi mate, this problem is known as Phimosis. unfortunately i have the same problem as you, my foreskin is extremely tight at the end, and the only time i can really get it back over is during sex when it's forced back, and like you said it's very painful.
I'm going to be tackling the problem...