Transpose Data from a Particular Column to Multiple Column whose Range is Non-Continuous!

Dear Friends,

In the attached Excel File, I have two Worksheets:-

Pivot Data Worksheet:-

There is a Pivot Table from a source File. Pivot table Rows in Column C will keep get changed (Increase/Decrease) depends upon the source sheet variation.

What I would like to accomplish here is:-

Whatever the data is there in “Column C” of "Pivot Data" Work worksheet from C5 cell onwards needs to get updated in “Working File” worksheet as transpose respectively G1,M1,S1,Y1…………………… (Note: Number of columns blank after each text is remains same i.e. 5 Columns)

Your valuable suggestion could be in the form of Formula or VBA as well.

Thanks & Regards,
Rajeshkumar R