Auto Formatting with VBA

Good Afternoon,

I'm fairly new to VBA, but can get myself through some things. The task that I have at hand seems to be getting the better of me. I have a software that balloons blueprints and we use the software at my employer, the software has "tokens" that excel recognizes and formats/fills the cells with the appropriate information from the application. The pictures below will illustrate my problem more. Is there a way I could write some script in VBA to where, when the information is exported from my application to excel using the template I have, will it automatically format? If I am not making much sense, I do apologize, it's harder to explain without working with it. First pic is my template that the software uses to export the data. Second pic is what the data looks like once it's exported using said template, and third pic is what it looks like after I format it to our standards. (which is what I'm trying to get automated, so we're getting away from human error and speeding up our process)
The range varies on each tab in the workbook, so I cant do a simple:
Sub copy_paste()
range.("F9:N9").copy("F18:N18")
End Sub

I'm not expecting anyone to write my code for me, I'm simply asking is this possible and if so, what direction should I go? Thank you in advance and I'm glad to be a new member here!

excelproblem1.png
excelproblem2.png
excelproblem3.JPG

I'll show as much as I can, legally. First picture is a snip it of a blueprint we have ballooned. Attachment 600151
We use the application to take a blueprint, balloon it and dimension it out accordingly. Second picture is how it is listed/dimensioned in the software. Attachment 600152
Third picture is the template with the "tokens", for example, token "${op_cn}" stands for operation characteristic number. Attachment 600154
That specific token fetches the characteristic number from the software when exported. Here is what I mean when I say "exported", Attachment 600155
The application takes the excel template with tokens, and once exported, produces this. excelproblem7.JPG
What I am trying to accomplish is once the file is exported, excel only automatically produces new rows for cells with a "token" in it. I want to automatically have excel format it where my employees don't manually have to do it themselves.
I understand this could be a big task and my not be doable, but I appreciate any and all help. I'm only allowed to upload 5 pictures or i would have given more detail.

Thank you once again!