Cells Referenced in a Formula

Good morning all,
I have a question I can use a bit of direction on,

I want to pull the cell references for each of the cell referenced in a formula. For example:

If in cells A1:A12 you have the following values, 41734, 34673, 49365, 40804, 32221, 35453, 38521, 51037, 56854, 30672, 14267, 21600. And in cell A13 you have the following formula:

=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12.

(In this overly simplified example) How would I pull the cells references (A1, A2 etc.) for each of the cells referenced in cell A13? Ultimately a list of cell references from a formula. Combined with transpose to give values in column layout

My current idea is to copy the formula and paste it in another cell with a “ ‘ “ in front so I see the formula. Then parse the formula based on the operator. Then build a string that is the tab name and cell reference.

My ultimate goal is to use this solution with the offset function to basically do a reverse vlookup.

Practical application: My boss routinely has me take over excel worksheets that he maintains that I will have to replicate for the following year. And my first thought is, how can I quickly see what cells he is referencing in his formulas without clicking into the cell, and manually writing the value from each cell in the formula.

Toggle your worksheet with CTRL + tilde (~). Then back again to see results.

Pete

Never knew about FORMULATEXT, great suggestion.
However what I am looking to do is pull the cell references out of a formula. I am able to see them, I just need to pull them out, and put them in a column

WOW, this formula does exactly what I need! This will be invaluable.
Thank you so much!!