Is the name of our Prophet Muhammad (peace be upon him) mentioned with the لفظ (wording/pronunciation) "Ahmad" in the Torah and the Gospel that are circulated today, as stated in the Holy Quran?

The Prophet (peace and blessings be upon him) is mentioned in the books of the Christians in several places, including what is stated in the Gospel of John, where Jesus (peace be upon him) addresses his disciples, saying: "Nevertheless I tell you the truth; It is expedient for you that I go away: for if I go not away, the Comforter will not come unto you." The word "Comforter" is derived from the Greek word "paracletos," which is a distortion of "periklytos," meaning Muhammad or Ahmad.

Moreover, the Gospel of Barnabas, which the Church rejected and prohibited from being read, appeared through a Latin monk named Fra Marino. This Gospel mentions Muhammad (peace and blessings be upon him) and corrects the concept of Christ's divinity. In chapter 22, it states: "This shall continue until Muhammad, the messenger of God, comes, who, when he comes, will reveal this deception to those who believe in God’s law."

The former Metropolitan of Mosul, Abdul Ahad Dawud al-Ashuri, mentions in his book "Muhammad in the Bible" that the common phrase "Glory to God in the highest, and on earth peace, good will toward men" was originally: "Glory to God in the highest, and on earth Islam, and to mankind Ahmad."

And in the Gospel of Matthew, it is stated: "The stone which the builders rejected, the same is become the head of the corner... Therefore say I unto you, The kingdom of God shall be taken from you, and given to a nation bringing forth the fruits thereof." This means that the message will be transferred from the Children of Israel to another nation, and the promised messenger will be from outside the Children of Israel.