Save excel to a specific sharePoint site. Must concatenation site URL with text in a cell

I need VBA Code that will save the excel workbook that is active to a specific SharePoint site. BUT

The site needs to be identified using the URL and the text in sheets(“Step 7”).range(“c21”)

https://group4.drs.com/activesites/17/material-estimating/_layouts/15/guestaccess.aspx?guestaccesstoken=YtbhvMF0mPAgIVnZhgBkZawm3aXfHL26y62iPYs%2flTs%3d&folderid=2_19eb0d5f566dd4eb0b5d2840565229fad&rev=1


Then it must show the new concatenation path in Sheets(“Step 7”).range(“c25”) as a active hyperlink

And

And it must name the workbook the text value in sheets(“Step 7”).range(“d11”)

If there is not a sharePoint site with the concatenation address Then error message stoping code and telling the user to check the sharePoint site to validate that there is a folder by the name of the value in C11

Note C11 is the folder name that needs to be concatenated with the URL pasted above.

C12 is what the workbook should be named - saved as.