Find all and display results

[rjfnc]

Hello all! I am new to the site and new to VBA. So to get down to it I need to create a macro to search multiple worksheets in a workbook for keyword then copy entire row of every keyword found onto a worksheet. It needs to search every column and display the whole row when a result is found. When the data was compiled into the workbook their was no proper fomatting.

Thanks in advance!

[rjfnc]

Also if possible for the results if the first column could be information about the location(IE worksheet name and what row. And multiple results.