Gender disappointment

Has anyone ever just been heartbroken over the gender of their baby?  This baby is the last chance to carry on his last name and I'm so so scared it's a little girl. I feel it's a boy but still scared it's not. And I'm so worried about disappointing my husband even tho he says he won't be. We love our five daughters more than anything but ready for some blue!!