You can add some small javascript code which will query to site pages library with Order by Modified time and with item limit 1.
Once you get item, you can get URL of that page easily. (You can use EncodedAbsUrl for that.
There are couple of way to query in SharePoint list i.e. CSOM or REST.
Below is the code for your requirement which you need to place it in CEWP HTML:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" x-undefined="" />
<title></title>
<script>
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', function () {
var requestUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/GetByTitle('Websiteseiten')/Items?$select=EncodedAbsUrl&$orderby=Modified desc&$top=1"
jQuery.ajax({
url: requestUrl,
type: "GET",
async: false,
headers: {
"accept": "application/json;odata=verbose",
},
success: function (data, textStatus, jqXHR) {
if(data && data.d && data.d.results && data.d.results.length > 0){
jQuery("#latest-site-page-link").attr("href",data.d.results[0].EncodedAbsUrl);
}
},
error: function (jqXHR, textStatus, errorThrown) {
}
});
});
</script>
</head>
<body>
<a href='' id='latest-site-page-link'>Latest Site Page Link</a>
</body>
</html>
Below is the place where you need to place that html:
Note that you need to load jquery as below code is using jquery. In my case jquery is already loaded so I haven't loaded it in CEWP.
Hope it will help you.