Ok, here's the scoop. My friend saw this movie when he was a kid. He told me this movie was filmed in the 1980s (sci-fi horror/ thriller). He really doesn't know what the movie was about but the film includes a red brain like object (big as a soccer ball), self opening, used metal to create a body thus forming a cyber-like creature that killed people. There was a space mission to the moon where they found a pyramid (on the moon), breathable air in the pyramid, and a female (Egyptian looking) who was frozen for a million years inside the pyramid. He also remembers a space ship that just showed up all of a sudden, orbiting the moon. A human astronaut rescues this Egyptian lady and takes her back to Earth. They kill the cyborg creature (the main hero) by shooting down through an air vent with a shot gun and exploding the brain. And finally (he saids) that the last scene in the film is of another red brain lying in a metal scrap yard.

If anybody knows anything related to this (hopefully the title) would be much appreciated.

I think it gotta be Moontrap (1989)

http://imdb.com/title/tt0097911/

That's it. Thank you.