copy sheet based on table, rename, and hyperlink table to new sheet

Hey Mike!

Can keeping the sheets "normal" hidden still work with the hyperlinks? I do not want to hide them in a way where VBA is needed to unhide them. The goal is to not clutter the sheets tabs

Attached the template workbook I am using to build the macro off of. Currently still having trouble with hyperlinks.

My goal is to have the Hyperlinks allow you to click on the Company name in Sheets("Opps") in COlumn A, and bring you to their respective Sheet, Sheets("CompanyA_Prcs") etc.

I am also having trouble getting the macro to avoid copying the header row, row 1, it keeps making sheets for Product1_Prcs, Product2_Prcs etc. This should be an easy fix with the ranges I have set but so far it's escaped me.

Thank you for the assistance, I greatly appreciate the support as I get back into VBA