VBA to search all worksheets, for multiple keywords, and copy matched rows

[patrickchau]

Hi,
excel have find function with can find all cells matching one keyword in all worksheets, within workbook.
but I need to find all cells which consist of more than one keywords in all worksheets (i.e. search cells which match all keywords) ;

and copy all those rows, with matching cells, to a single worksheet named"searchedresult";

and if possible, have an extra columns in the searchedresult which have the hiperlink for each matching cell, which allow me to click and go to each particular matching cell when needed; name of worksheet found and cell address.

Would it be possible to have a VBA which will prompt to ask for keywords to be searched (each seperated by ";") then carry out the search and put results as described above.
attached a sample excel

thanks a lot.

patrick