Thanks - to clarify what I need to do:

Say, for simplicity, I have a set of values in 10 cells (A1:A10) in
sheet1 of a workbook which
also has comments in each cell. If I have another worksheet
(worksheet2) and want to replicate this column of values, I just enter
"=Sheet1!A1" etc. But this does not also return the comments.

I want references to return both the values and the comments (as
comments).

My real spreadsheet is a larger one, hence why I want this to be
automatic.

I am a VB novice although follow the basics so I could follow some
clear guidance - I think!

Thanks