VBA Build Table of Contents For All Numbers

I am trying to catalog every number on a given sheet. The challenge has been when special characters are included, numbers repeat, merged cells, values are within paragraphs. I have attached an example. Imagine excel in the background tagged every number, I've included an image to try and explain.

So the visual aid is just to help imagine the idea, but the goal is to translate that to excel and a tabular like approach. Is there a way of accomplishing this?