Create VBA to create table for each row with the same start

[jrbarcik]

I have multiples txt files and I would like create VBA to transform txt in tables.

Example:
file_01.txt

|000|12162020|XXXXXX|
|001|421,34|0,50|210,67|
|001|523,45|0,50|261,725|
|005||

file_02.txt

|000|11162020|XXXXXX|
|001|400,00|0,50|200,00|
|001|100,00|0,50|50,00|
|005||


------Table_000-------
|Date | Name |
---------------------
|12162020| XXXXXX |
----------------------
|11162020| XXXXXX |
----------------------


------Table_001-------
|Date | Price |
---------------------
|12162020| 421,34 |
----------------------
|12162020| 261,725 |
----------------------
|11162020| 400,00 |
----------------------
|11162020| 100,00 |
----------------------

How I make VBA for create this situation? (Table_000 and Table_001)
Thanks