The sermon explores God's presence with his people in ancient Israel, the church, and the future New Creation. It describes how God's presence was manifested through the Tabernacle in Israel, and how Jesus' sacrifice removed barriers, providing access to God. It concludes with the vision of God's eternal dwelling with humanity in the New Creation.