After more tests, I have concluded on the followings.

The Paste link is the one which is the closest to what I need.

My sheet 1 is named Monthly. Thus, on sheet 2, from the Paste result, I see =Monthly!G5. Thus, the reference to sheet 1 is preserved. However, instead of using the source of sheet 1 G5, which is =$A$55, it establishes a static reference. This does not serve any good as the goal is to move that section from sheet 1 into sheet 2. Thus, as soon as the content will be removed from sheet 1, the cells from sheet 2 will become 0. Also, I really need to preserve the original formula from the cells in sheet 1 that I need to copy into sheet 2. Thus, sheet 2 should be =Monthly!$A$55 or whatever the syntax should be.

Then, the second issue is that I need to preserve the formatting. A Paste link does not support the format.