Redirect collection page to a static URL on load

Hi, I have a portfolio site at

https://preview.webflow.com/preview/brother-2022?utm_medium=preview_link&utm_source=designer&utm_content=brother-2022&preview=a13299ae9fc04c5e595e62df3de57624&workflow=preview

I have created my portfolio pages as standard Webflow pages because I need to be able to have some control over how the grid lays out the images and copy (ie. they are not uniform in appearance with images inserted around copy, videos, lotties etc).

However, I would like to navigate through the pages with next/previous navigation but don’t want the headache of managing these manually.

So I have created a Collection called “Collection to pages”, and within the Collection settings, have added a field where a redirection URL is placed.

What I would like is when the next/previous button is activated, the next post in the collection is called, and the redirect then sends the user to the static page entered in the redirect field.

Any ideas?

Dominic