How to read text data from .dat files and fetch the data in to excel based on input..

Greetings!

Problem Statement: How to read text data from .dat files and fetch the data in to excel based on input criteria entered in Search Field in user form built
--------------------------------------------------------------
Please refer attachment of prototype zip file and extract to local test folder that has sample excel file and sample .dat files(the text data can be seen by opening in notepad)

REQ tab has details on need and referring here below the high level.

looking for a function / program that should read all the .dat files from selected folder and Search for TokenID# (user will enter Token Id and this value as input for Token Id search criteria for example(1113265055) which is the input parameter to verify whether the number exists in .dat file/.dat file's or not.

If matching Token Id number found (TokenId# would be field5 value in .dat file always) in .dat file then that record needs to be written in to BID1 worksheet tab in the attachment with ecah value in to unique column. Every Record ends with ; is the identification for end of the record.

appreciate any help on this.

Thanks
Mahindra