Macro to copy cell that has changing value to highlighted cell

[Lobz]

Wondering if there is a way to copy a cell value and paste it in another cell. The cell that is copied is part of a calculator I have set up so the value will change based on the values for the calculator and I would like the "total" cell to be copied so I can paste it in a cell, on another sheet, that I have clicked or highlighted. I would like to eventually figure out how to use a user form (for the calculator) or something like that to enter the value into the highlighted cell but I'm not at that level yet.
Example: Copy Sheet2 C10, paste it in highlighted cell in Sheet1
I do not want it to change the values of other cells that have used the calculator "total" cell as reference either.
If there is a way to do this or I need to explain more clearly, please let me know.

 

[Lobz]

If there is coding or a way to record the macro, I am open to options.

 

[hartless43]

If I understand correctly what you mean. Go To Sheet 2 C10, click on copy, then go to Sheet 1 to the cell where you want it to be and click on that cell and "paste link". I am learning how to use the UserForm and it's a neat thing to use, but can't help on that.