swmen | SwooleLumen - | Application Framework library

I have imported a bunch of data from tables in Word -> .txt -> Excel, but in the conversion to .txt the format of the table is lost and I am now trying to recover it in Excel.

I would just make a simple Copy/Paste Macro based on the Cell Range, but the cell ranges are not the same across each imported .txt file so this won't work as the same data could be in A8 in one sheet then A10 in another. You could almost move every other row into column B, but the "Date Due" field throws it out of sync.

I want to transpose the copied date into a more functional table format - see picture for example - which I can then analyze. I need to do this for hundreds of sheets but I'm hoping that if I can get it working for one then I can adapt it to work across many.

Each sheet may have multiple products, each new product is preceded by an integer (e.g. 1. Product1; 2. Product2 etc...)

deleted old code that I'd tried to do

EDIT2: screenshot of typical notepad file

There is a load of text above this, but the first product always starts with QUOTATION MACHINE SCHEDULE, then 1. xxx

EDIT3:

Tried to add in the column I to have Quote Ref: and find this in the text file, but it didn't work. Code change from CDP1802 current solution below