Create a macro to import semicolon-delimited text into template

I've tried this a few times using the macro recorder, but the result is always that the macro will only work for the one text file used when it was recorded. Is there an easy way to alter what was recorded, or setup an easy macro to import a file into a template with a userform? I just started working with macros, and this is beyond my capacity right now.

Attached are the sample text file, and the template that it needs to be imported into.

Here's the macro as it was recorded:

Please Login or Register  to view this content.

Thanks!