I need to parse multiple text files from a folder, then put the results in different excel sheets.

I have a folder with multiple text files.

I need every file to be read and parsed, then I need them to be put into an excel file. for every file there needs to be a sheet. Noteworthy is that I need to be able to do this in different folders. I don't always know how many files there is but it can be everything from 1-1000 (very unlikely that it is 1000 though).

I can't seem to find a good way to do this. I think its best if I just show you an example of the text file, images below. FME might not be well suited for this, I know I can do this in VBA in Excel, But I really want to do this in FME because it is way easier to share it with colleagues and more reusable.

This is what I have, this is how one text file looks like:1: I need the file name to be the sheet name.

2: This is meta data, I need this to also be in the sheet, or in a separate file but with the correct file namne.

3: This is the table with information that I also need.

So what I need is this. A clean table, and for every file in the folder, a sheet with the file name. Note that the metadata is not in the picture but would be needed as well. Any starting suggestions? I have a very messy workspace and I could share some things. But I think I mostly need to think about this in the right way first. Also I didn't really know where to put this question.