I think the biggest issue would be fuel. Trips to the Moon were very carefully calculated: they brought just enough fuel to make the trip. The amount of residual fuel left behind in any of the landers remaining on the surface is minimal. It was minimal the day they landed. In the 40+ years since then there has surely been some leakage, and probably chemical deterioration. Even if you somehow could visit all the vehicles on the surface and collect all their fuel ... well, I'm too lazy to do the research for a casual post like this, but I doubt it would be enough to get an adult human off the surface and escape from lunar orbit.
Then there's the fact that none of the vehicles left on the Moon was built to take off. These are LANDERS, intended for one-way trips. Could they be modified into launch vehicles with sufficient time and effort? Maybe. I guess that's less impossible than finding fuel.
You could speculate about what a sufficiently ingenious person could do. Like Kirkaiya says, maybe a McGyver could figure out something brilliant. Could you somehow build a machine that would produce fuel from lunar resources using parts from various landers? I can't say that it's impossible, but it would be very, very difficult. Heck, would you even know how to start? If the hypothetical stranded person was an engineer who designed fuel refining equipment back on Earth, maybe he could. But most people, even most highly intelligent people, would likely have no idea how to go about building a fuel refining machine. I think I'm pretty clever and I have no idea. And people who do know would probably have no idea how to identify the type of rocks that include the appropriate raw materials, and vice versa. Modern technology is built on the work of many, many specialists, each contributing their own little piece to the complete system.
And if you are going to combine parts from multiple landers, how will you travel between them? Are we assuming you have a vehicle that can travel hundreds of miles across the lunar surface before you run out of air, food, and other supplies? If we're assuming you're on foot in a spacesuit with a few hours or even a few days of air, forget it, I think you're doomed.
Finding a working or repairable radio so you can call for help seems a lot more promising. Even without a radio, a clever person might come up with some way to send a message -- writing SOS in big letters with some available material, maybe using a small amount of fuel to send up a signal flare, using a mirror to flash light, etc. Most of these would require knowing when someone will be looking in your direction.
But even if you could signal for help, then what? Unless the folks back on Earth just happen to have a moon-rocket sitting around -- didn't I leave one in the garage last fall? -- how are they going to rescue you? By the time they built a rocket, launched it, and reached you, you are probably long dead.