How to copy a cell along with its comment using a formula?

[edge37]

Hello, I have been searchinga way to do this with no success. I want to be able to copy a cell that already has comments included to another cell (in another sheet), but I need that the comment also get copied. For example, in the pic I sent, I want to copy B5 to another cell. The sheet is called 10A (1), I would use the formula (in the final cell):

='10A (1)'!B5

to get the cell copied, but this won't copy the comment that the cell includes. Is there a formula I can use to copy content + comments to another cell?

Thank you

 

[Joe4]

I don't think that is possible with native Excel formulas.
I think it would require VBA code do that.