When you go to another worksheet via the tabs at the bottom of the Excel window, the Comments pane updates to show comments in that sheet.