If you were in Cumbria or SW Scotland, I would be pointing you in the direction of Derek Scrimgeour, who gives clinics near Wigton (between Carlisle and Penrith) and is tremendous at finding out what your dog can do, and helping you discover what you can do.
He goes all over the world teaching all
kinds of people to work collies and I know of several he's taught as adults who now perform very creditably at trials, despite having had no prior experience.
And another of his students came to it as an adult too, and not a young one either, and now uses her collie dogs on her own and her other half's sheep. The younger dog I've trained myself with a bit of help from Derek to 'start' her. (Yes, it's me

)
So, first off, yes you will be able to do it. Anyone who has enough determination and some empathy with dogs is going to be able to do it.
As you can see my border collie would have no clue what to do either so do you think if he had the drive to work sheep it would be best for me to train him up once I had trained myself? OR should I buy a started/partly trained/trained sheepdog and learn with a dog that already knows the basics?
A collie that has work in it actually
will know what to do. Derek's style of training, which I like very much, is to get the dog doing its natural behaviours around the sheep, then 'put a word on it'. So he'll get the dog running around the sheep, and as it's going anticlockwise he'll say, "'Waaayyy". He'll then shift his body so the sheep move, causing the dog to change direction, and as the dog changes, he'll say, "Byyyyeee". Pretty soon, the dog associates the word with the action and you can start to ask for the action with the word. Simples.
Of course, Derek has Xty years of experience of sheep and collie dogs, and knows precisely what to do with
his body to make the sheep move
so and the dog move
so.
Oh, and one of his came-to-it-as-an-adult has performed well in nursery trials with rescue collies that didn't seem to have work in them - so it can also be done, though it's a lot more work and probably not as much fun for the collie, with dogs that don't naturally work, too.
I went off to get the link to
Derek's website, and I see you've had some recommendations for trainers nearer to you. Best of luck!