VBA Code to lookup values in a cell and display results in a pop-up box

Hi hope someone can help with my VBA headache!

I have an Excel workbook, see attached for example, in which 'Sheet 1' is an example of the first sheet that contains a list and against each entry a string of numbers each one of which relates to an item in a list detailed in 'Sheet 2'. The number in the string can be variable.

Sheet 3 is a 'mock up' of the ideal results, if you were to click or hover over one of the cells containing the strings of numbers. The location of the pop-up containing the selected data would actually appear on the screen might be a bit random.

So the code would need to activate when the mouse hovers or clicks on a cell, then strip out the individual items in that cell, look each one up from a master list then display in a pop up box the resulting list which would need to be sized appropriately to display the data.

This is part of a bigger spreadsheet so cannot be done in another tool, can anyone advise if this is possible and give me any pointers please?

Any help very much appreciated.

Cheers
Neil