import txt or csv delimited parts into different excel sheets

Hello friends,

I'm an Excel 2013 user.
I'm using some Excel macros to extract some data from a big .txt file. Big means more than 400k lines.
Parts of this file I extract them into different sheets.
For this I have a nice macro, that extracts all the rows found between % ... %%% symbols.
Here attach is the code that is working fine.

My new challange is to modify somehow this code so to add also the first 8 lines of my .txt file that are not delimited between these % ...%%%.
These lines I want to put them on the 1st sheet (or the 2nd, because on 1st sheet I'll put some butons to run the macros).

A sample file with that I'm using it to extract is also attached. I run the macro, a new window opens and i choose the file to be extracted. On the excel, on column A I have all the tables / names of the sheets that will be extracted from txt file.

Would you be so kind and help me with this?

In advance many thanks.

If this is not what you wanted, need to see your desired result in a workbook.
Change "test" procedure to below while the other function must be kept intact.

Please Login or Register  to view this content.

Hello buddy ,

Thanks for fast reply.
Your code extract the first 8 lines and add it to every new created sheet.
My ideea was to extracted only once, and to put it in the next sheet after Sheet1 (and if possible to name it INDEX - it would be great).
I attached an example of file, with sheet 2 named Index, extracted string is in B2-B3-B4 because i want to delete afterwards the Column A to remove the % signs.

please see attached archive
apreciating your time

Change to

Please Login or Register  to view this content.

Thank you my friend.
This is what I was looking for. You are really good and helpful.
You made my day really happy.

Have a great day!
Keep up the good work!