Here is the process I believe would work for you.
-
Collect all sheets
-
Collect all views on each sheet
-
Check the view for revision clouds visible in that view
A. Collect Element in view vs All elements in Active View -
Get the comment from each revision and then write it back to the sheet.
Sorry I haven’t been at my computer, but I can try to put this together when I get a chance.