To paste a cell from one worksheet to another by a reference cell

[lyon2021]

Hi, I'm new on VBA. How to paste a cell from one worksheet to another through a reference cell? For example, I wrote a formula "=INDIRECT("'"&$G$1&"'!"&"A1")", G1 is from sheet 1 and contains the name of the other sheet. A1 is a cell of the other sheet. So if I put this formula into a cell of sheet 1, the content of A1 on the other sheet will be showing here.

Now I try to do in opposite. My question is : How to copy a cell from sheet 1 (like cell B1) and paste to A1 on the other sheet. Many Thx!!

 

[RayFrye]

Have you searched this forum or any other forum for an answer or even a clue?
Have you created a single line of VBA code?
If you have created a subroutine and it doesn't work for you, paste the code and someone will help you.