In order to have a period that matches the Earth's rotation, a satellite must be in a circular orbit, and 42,164 km from the center of the Earth.
But that's not quite enough to make sure that it always stays over the same point on the Earth's surface (and appears motionless in the sky). For that to happen, the satellite's orbit has to be directly over the Equator.
The Moon has nothing to do with any of this.