Macro to Open another template and use the Cell in the new sheet

I am creating a Quote # log that is also a sales funnel for our company. I
would like to:

First: use the first column cell as the quote number...and when you click on
that number. It would first open a specific quote template...then use that
quote number to fill into a cell on the template that was opened.

I would then like...when the person "saves as" a hyperlink to be created in
the cell on the quote # sheet to link that quote.