Connect a Heading with Subheadings

I am currently working on the following excel sheet: this is the excel sheet

I am quite new to Excel and I just found out about the VBA function. Do you guys think that it is possible to write a code that does essentially the following:

If [Total Debt Stock] -> select the next 6 cells below and add to these cells "TDS" at the beginning.

And follwing this: If [short-term debt] -> select the next 2 (for instance) cells below and add "STD".

The aim is to copy the following pdf and also keep the "embeddedness" structure of the pdf (i.e. Albania-Total Debt-Short Term Debt- Official creditior) so that STATA can use that easily this is the pdf

Has anyone ever done something like this?

Thanks in advance!

All the best, Greg