create hyperlink to another sheet when specific selection is made on a dropdown

I need to develop a macro that will create a hyperlink (on Sheet 1 column P) to sheet 2's next blank record in column A when a dropdown selection in Column K (on sheet 1) has the first word: "Cable". I would really appreciate help on this.

Thank you this works well for me. I wondered though, if rows are inserted on Sh2 after the hyperlink was created is there any way that the hyperlink can automatically adjust to match the change? Or is this waaaaaayy too sophisticated....

thank you tehneXus - Your code works well too thanks, but I needed the hyperlink to be recorded on Sh1 so someone could go back to it later and click on it and it would go to the proper data on SH2. Your code put the hyperlink as "next free row" . I appreciate the effort though, and I probably wasn't clear enough on my requirements.

Thank you this has really helped, can you please provide additional help on how to integrate this next issue into your code? How can I also have the selection of "Cable" in column k to also trigger a copy of Cells A, B and J from Sh1 to Sh2 into the same row the hyperlink has referenced?