Hyperlink Materials in Google Sheets

I have four Google Sheets—one each for roofing, siding, decking, and exterior painting—already populated with every material my crews use. Alongside those sheets I’ve compiled a complete set of manufacturer URLs for each item... (Budget: $10 - $30 USD, Jobs: Cloud Computing, Data Entry, Data Management, Data Processing, Excel, Google Docs, Google Sheets, Link Building, Web Scraping, Web Search)