Macro to find specific text within directory XLS files and output data to new worksheet

Need macro to find any instance text stating 'see reference' within directory of xls files and output file name where instance occured to new worksheet.