VBA Excel code for importing and formatting data

I have a .txt that needs to be imported to a .xlsm file and parsed into a column format. I am attaching 2 files: - The .txt that contains the raw data - A .xlsx used as an example of the structure that needs to be followed There are 3 tabs, the first one with a button that will execute the code, the second one is where the data is going to be imported and formatted, the third one contains an example of the end product. Instructions were added in the excel file. The deliverable needs to be ready in 2 hrs after winning the project. All the code needs to be properly formatted and ideally commented (in English or Spanish). Please include in your bid the steps that were added in the excel file as reference and start your bid with "Howdy!" to know that you read the requirements. If you have any questions please let me know. Thanks!