Create a ToolTip

Hi 

I am looking for help to try and produce VBA code, to create a tool tip that will update as I add more content to worksheet.

I have two reports, both on the same workbook, one use to log comments frequency, there will be many comments for one project and there is a main financial report which just list the individual projects but I want to see the comments, if any are logged,  for that project.

Example Illustration - 

Report 1 is where I log my comments, these are added every so often:

..and the desired outcome, on the main report which is on the same WorkBook, this is the outcome I was hoping to achieve in a comments field or similar: 

When I select the cell that contains 'ABC123', the route/VBA the code matches that string on the comments page and produces a comment box with the data held on the comment page.  Each Week/Month more comments can be added so there may be next time 3 comments for 'AB123' and so on.

Any pointer would be greatly appreciated.   

I am using Excel 2016 for Business

Chris