Create Hyperlink on a Cross Reference to STYLEREF Heading 2 in the footer? PLEASE HELP

The short answer is no. StyleRef fields do not support hyperlinking.

You will need to use Section breaks between your headings, unlink each heading from the previous Section, then insert a hyperlink (or hyperlinked cross-reference) to the relevant headings, on a Section-by-Section basis.

Note: While hyperlinks situated in the body of a document to a bookmark anywhere in the document do work in PDFs created by File|SaveAs in Word, hyperlinks from a header/footer don't work. PDFs created by other software may behave differently.

So I will have to manually do this on each and every page, or can I make it part of the style?

You will need a Section break for every heading. Whether that means every page depends on whether there's a new heading on every page. Making part of a Style won't achieve anything.

I was getting some hints elsewhere online that maybe Character Style might be possible?

For StyleRef fields, yes, but not for what you're trying to do.

If it is a page by page fix, then it just isnt scalable. I might have to attempt it in InDesign or something.

In Word, the process could be automated with a macro that goes though the document, doing all the work.

A slightly different approach, which avaoids the need for Section breaks, is to put the hyperlinks into textboxes anchored to the body of each page. Again, a macro could do this.

Ultimately, whatever approach you opt for, this isn't something you'd want to do to a document that's subject to ongoing editing. Rather, you'd make a production copy and do it to that, so the 'master' remains ediatble.