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)
[TABLE="width: 1011"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]17231980.1[/TD]
[TD] | REVISION FEMORAL BROACH TRIAL BOLT[/TD]
[/TR]
[TR]
[TD="align: right"]17231980.2[/TD]
[TD] | REVISION MACRO SOLID FEMORAL TRIALS CASE[/TD]
[/TR]
</tbody>[/TABLE]

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 >