I asked a question on how to get a character to move relative to the camera. Since then I have found a set of videos that explain how to set this up with blueprints. I have had a few private messages asking if I had figured it out so I wanted to provide these resources to everyone.
All credit goes to CodeLikeMe
Unreal Engine 5 Fixed Camera System
Unreal Engine 5 - On Rail/ Fixed Path In-Game Camera System
Unreal Engine 5 - Preplanned Movement Directions for Fixed Cameras