Hi there,I need others opinions on my predicament as I am in despair and feeling torn in two?

My husband has a very physical manual job and has had a few health problems over the past 3years,mainly due to an accident he had at work and now due to the type of work he does he has a problem with his left knee and is waiting for an operation.He is 62 next January and we have both agreed he needs to retire before he completely wrecks his body or else he wont have any quality of life when he gets to retirement.To enable him to do this we need to sell our house and this is where the heartache begins.To buy anything that is half decent we need to move away from our youngest daughter and our granddaughter and our daughter is also due another baby in November.We have 2other daughters but 1 has moved to Australia and the other one lives up north.My husband realises it will be a wrench for me but I don't feel any of them realise the turmoil as my loyalty should be with my husband but I also want to be near my daughter and grandchildren.My husband is a very quiet man and isn't a great mixer so I have had to make all the friends in the 40years we have been married.I am feeling bereaved inside and cant sleep and no matter what decision I make inside my head I keep finding reasons to change my mind.What would you do?Oh I forgot to mention,my husband has just cashed in our endowments so even if I said no I want to stay here we cant as we wont have enough to pay off the mortgage when it finishes in 3years.