Open Multiple workbooks and if you find "Rejected" copy the entire row to master workbook

Hi All,

Happy Friday...

So here is my case: We receive excel spreadsheets from vendors and we move them to a folder. We then have multiple people opening them up and filtering for "Rejected" if they find one the copy it to a master rejected workbook. I was wondering if i could create a macro that would open all the spreadsheets and find the key word "Rejected" and if found copy the entire row to the rejected workbook and the macro could be within the rejected workbook. Now they all should be standared meaning the rejected not should be in column "P" but there is no way to be sure it will.