Bring Comments from multiple sheets to one sheet

[Madara]

Hey all,

I have a workbook which contains multiple sheets for users. And each sheet contains users comments or no comment at all.

I want to bring all the comments (if there is any) to a specific sheet.

Here is an example file.
https://ufile.io/0arac

I want comments of all sheets named "Janis", "Eduards", "Ainaz", "Mary" to be in "Comments Sheet". I hope i'm clear!

Thanks!

 

[Madara]

bump

 

[sandy666]

is that what you want?

Comments

Comment of Ainaz

Extra Comment of Ainaz

Extra Extra Comment

Comment of Janis

Extra Comment of Janis

Mary Comment

you can try with PowerQuery

example excel file

 

[Madara]

Yes exactly. Thank you very much! I ll try power query

 

[sandy666]

You are welcome

Have a nice day