ideas for creating linear movement/ general suggestions for approach please

You could just use threaded rod from a hardware store.