Hi, I'm new on VBA. How to paste a cell from sheet 1 to another sheet by a reference cell in sheet 1. 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 the opposite way. My question is : How could I copy and paste a cell from sheet 1 (like cell B1) to A1 on the other sheet. Many Thx!!