How to copy a vertical range of data horizontally after nine successive columns in a row?

I have three sheets in my workbook named "Range", "Plan", and "Print".
If "1st Range" is selected in "Print!C6" cell of "Print" sheet, then "Range!C7:F7" data of "Range!C6:V150" range is copied and pasted in "Plan!A7:D7" range of "Plan" sheet.
In this way, after nine columns, "Range!C8:F8" data should be copied and pasted in the "Plan!J7:M7" range of the "Plan" sheet. In this way, nine consecutive columns of "Range!C7:F150" vertical data should be pasted in the "Plan" sheet.
Also, filter the non-blank rows of the "Range!G7:V7" range of the "Range" sheet and paste the data corresponding to the "Range!G6:V6" range into the "Plan!A8:I9" range of the "Plan" sheet. In this way, nine consecutive columns should be pasted in the "Plan" sheet next to the "Range" sheet.
Thus, if "1st Range" is selected in "Print!C6" cell of "Print" sheet, then "Range!C6:V150" should be used.
And if "2nd Range" is selected in "Print!C6" cell of "Print" sheet, then "Range!AB6:AU150" must be used.
And if "3rd range" is selected in "Print!C6" cell of "Print" sheet, then "Range!BA6:BT150" should be used.

What happens when we get to G12 of "Range" as we have a new heading "6/CT" ???

Originally Posted by JohnTopley

What happens when we get to G12 of "Range" as we have a new heading "6/CT" ???

The data of "G12" will be copied to page 6 of the "Plan" sheet. The new heading will be –

6/CT 6/ET 6/PT
24 36 12

Please Login or Register  to view this content.

I sincerely apologize for the late response. I am thankful to you for taking so much time to give a perfect solution to such a complicated matter.
Anyway your code is working very well. But there is a small error. For example "4th Range" and "5th Range" are showing output even though there is no data, which is not desired. Will you take a look at this?
Also I don't know, does the "module-2" you provided have any effect on the output?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You/re very welcome and thank you for the rep.