find content in closed workbook

I want to do the equivalent of "ctrl-f" to find content in a bunch of closed workbooks.

More specifically: Given a string, I want to search for the cells that contain this string in all the workbooks in a directory. Then I want to return the location of those cells (workbook, sheet, cell). I have been trying to do this using power query and I have no experience using VBA.

Any ideas?

David