Double Click Macro that creates new sheet using SQL query (Please Help!!) =)

Hello, I am still in the process of learning macros, and I was tasked with the following scenario, please help steer me in the right direction!

I have an excel workbook that is populated with lots of pricing information. Column A is the product_ID and I want column AP to be the lowest competitor price for that product_ID. I also have a SQL table named Competitive_Pricing and a query that uses product_id to pull ALL competitor pricing for that inputted product_ID.


I would first want to create a macro that populates column AP with the lowest competitor price by plugging in the Product_ID from column A into a query that pulls lowest price for that inputted product_ID, then another macro that when a user double clicks on a cell in column AP (lowest competitor price for that product_id in column A) it creates new sheet. This new sheet would be populated by plugging in Product_ID from column A into my SQL query, pulling all competitor pricing for that specific product_id. Once the user clicks onto a different tab than the created sheet would disappear.

Can anyone please help me write the VBA code that would be used to do this?