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?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#D9D9D9]Comments[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Comment of Ainaz[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Extra Comment of Ainaz[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Extra Extra Comment[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Comment of Janis[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Extra Comment of Janis[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FFF2CC]Mary Comment[/td][/tr]
[/table]

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