getResources returns which is then used in a Weblink

I'm developing a school website where each week a PDF newsletter is placed on the website. For each newsletter, a Weblink Resource is set up pointing to the PDF. GetResources is then used to sort and display an archived list of these Weblinks as new newsletters are added. No problem there.

I now need to create a Weblink called "Current Newsletter" which should always link to the most recently added newsletter. So basically, my Weblink needs to link to a getResources call which returns the weblink of the newest resource. Can this be done?

I know I can achieve a similar result using Wayfinder and hiding all the old newsletters from the menu, but this would mean my client would have to name the resource "Current Newsletter" and once it's archived, rename it to something else. It's an extra step I'd like to avoid.

Perhaps I'm going about it the wrong way, so I'm open to all suggestions. Thanks!