The only cure is to remove the complete headlining and remove the sunroof trays.
Seal up the gaping gaps around the winder handle or electric motor mounting points and seal up all small holes in the pressing. Also seal where the clips hold in the roof blinds.
Remove the plastic drain pipe...