Grab Columns and repeating Pay Period Rows into a stacked sheet

I have painfully manual process that takes me forever to do and it will be regular. The file contains 3 sheets.

1. Productive Premium Worksheet - this is the sheet we use to input the data and it aggregates and splits into pay periods.
2. Pivot - Takes data from Productive Premium Columns FG:GG and aggregates into first the cost center then to Job class Facility and Pay Type (which is always Productive Premium).
3. Load file - I have to manually copy the cost center, Job Class, Facility and Pay type, and the Amount to the corresponding Period from the Pivot. The trick is this has to be stacked on top of each other so I have to go column by column replicating these columns and stacking them on top of each other into to the corresponding Pay period. Column A will always be called PAYBUD2022. in the Load File sheet.


Is it possible to write code to aggregate the data so that it looks like the Load File sheet?

Thank you for your consideration.

Although I am not a coder and probably can't help too much, I feel that in order for anyone to help we need some more information. For example, I am not sure why the Load File sheet doesn't display 10600 as the first cost center as on the Pivot sheet? Why is coast center 10680 in B2 and B15 on the Load file sheet but when it is in A6:A8 on the Pivot sheet? I imagine that the more detail we know the more likely someone can help.
Let us know if you have any questions.