Import Section in Multiple Text files into 1 Excel file

[D10685]

I have one tag I need imported, along with the file name, from multiple TXT files into 1 Excel file (preferably Column 1 file name, column 2 the tag shown below). I only need the text within the tag.
<phrase translate="true">REVISION TIBIAL SLEEVE SEPARATOR - DRIVER</phrase>

Excel example:
COLUMN 1 | COLUMN 2
(file name) (tag content)

17231980.1	| REVISION FEMORAL BROACH TRIAL BOLT
17231980.2	| REVISION MACRO SOLID FEMORAL TRIALS CASE

<colgroup><col><col></colgroup><tbody>
</tbody>

Does anyone have a macro that would work for this? With my very sparse knowledge on Macros I can run them but no idea how to write one this specific.

Thanks in advance!

 

[D10685]

oops the tag disappeared on me, lets try it with some spaces added:

< phrase translate="true" > < /phrase >