import multiple txt files in worksheet and formating

[-haf-]

Hello,
I'm newbie in macro but i know something of programing.
My problem is somthing like this:

I have folder with multiple txt files (eg. 546.txt. 432.txt, 343.txt)
Content of every file have same formating but different data

546.txt
-----------------
Header
Number: 546
Value1: 1345 675
Value2: 323 245
Value3: 4322 343

432.txt
-----------------
Header
Number: 432
Value1: 32 444
Value2: 78766 245
Value3: 12 714

Importing delimiter that i have to used is "fixed width" because i
cannot get good import. For Values row there is two numbers i need that
are delimited with multiple spaces (not tabs).

From every file in working folder i want to import only rows Value

And would like to my excel sheet look like this:

Number Value1 Value2 Value2
432 32 78766 12
432 444 245 714
546 1345 323 4322
546 675 245 343


Can someone help me with this?

 

[-haf-]

nobody knows, or nobody helps