Go here:
Ford Escape & Mazda Tribute Sunroof Repair Kit
Maybe give them a call... and look for a local repair company. A LOT less than the $900 I've heard of for the factory[total] replacement part.
Or, if you are adventurous, and don't fear removing the headliner, do it yourself. They provide instructions. I'd like to see the instructions before jumping in myself.
tom