Keyword Accuracy Macro Required

Hi All,

Im new to the VBA scripting world and taught il call upon the pros to help me out.

I need a simple macro which will run against a list of keywords ex:cell-phone-carrying case pull out the line items relating rows with this keyword with the accuracy percentage against the row.

Sheet 1- Data sheet Row 1 will be the data and Column A will be the line to search on.
Sheet 2 - Keywords (ex:cell-phone-carrying-case)
Sheet 3 - Result showing the rows matching the keywords in column A, column B- coresponding keyword and column C accuracy percentage.

Please help as I have a huge dataset that needs to be covered and I have attached the sample sheet for vieiwing.

Cheers
Alvin