1991 Camry: How can I manually close my sunroof
I opened my sunroof now it won't close. When I push the button to close it makes a grinding noise and won't close.
Now this is from a later model but should still be valid for yours as well. from here Remove the front sunglass holder and pull down the front of the headliner then you can access the sunroof motor, if the cable has only separated and not completely jammed itself in the housing then you should be able to remove the sunroof motor and manually pull on the glass forward to position the glass back closed, you can not however position the glass up/down manually because the cables are directly connected to the lift arms and require motor drive to position up/down.
Now that is for the sunroof I think this is the one for the moonroof. To close the moonroof
Ultimately of course, you will have to get it fixed. It does sound like either your motor or the gear sub assembly will need to be replaced. This Forumhas some great info. Not very pretty images but they do give you an idea. Good Luck