Help needed! share data between worksheets

Yes. Thanks LZ. I’m not sure what happened to my post, however I did reply.
Basically I said Thanks for your detailed explanation, it is between two seperate workbooks, I did try locally on my computer first, it simply adds the written link, so perhaps it’s a Mac issue?? It could be an issue with my Mac Excel, it is the enterprise version also. I know in the past I have managed to link on my old computer, so that is why I knew it does work.
I’ve tried your solution, however for some reason it hasn’t worked.
I appreciate your help thus far. Cheers.