I'd export each one as CSV (I use CSV for all my bank statements, from their sites)

Then I'd grep on TEP and merge the files, and then do whatever. (open in Calc. It's an excel clone)

grep TEP * >> TEP.csv

Use the parent directory in case TSV.csv decides to grow endlessly.

Simple enough for grep and cat.


=============
If not, perl will do lots and lots.

Luv my command line.

I used to use a relational database known as /rdb, written entirely in perl that used flat data files.

https://github.com/ironsmith58/RDB

That would leave me with more that 30 files.
I thought there might be a way to do this within Calc.
Can I define a range and search that range?

If they are all in the same file, as opposed to each in its own file (I can't tell) then something internal is possible, but that's beyond me.

1. If they are all in the same file as "separate sheets" then export it one CSV and see.

2. Otherwise, some internal operation might work.

I am better at the former than the latter. Most people are the opposite.

Good luck.

https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_LOOKUP_function

I appreciate the simple explanation on how to use Calc. search.

if calc does not, import your data into excel .

i got used to it when i was working, but these new versions in win 11, well. i'm glad i retired.

actually, i just came back from the new xcel version. they no longer do it that way. but there s a screen to "automate" and it looks like they will walk you through a "script." i'm going to do a little of that late tonight or tomorrow night.