Search data within files and return specific data as output

Hello, I have a folder which has many TSV files and in that one TSV file has brand names written in one column and in other column it has names of other files. My requirement is when i give brand name it should search that name and in the same row other column it has file name. Then it should look for that file in the same folder and in that file it contains data such as ID and part numbers etc. Then on searching part number it will give ID in the same row other column. Output required is that ID. I am manually searching and doing this for every product. Hence i want this to be automated through python script.