Transfer data from Input sheet to output sheet on condition

Hello Experts,

Need you assistance in transferring data from Input sheet to Output sheet on conditions..

Please see the attached File..

Input Sheet have Column C (Values as 1,2,3) & Data from (Column E to Column U)

Now Transfer all Data from INput sheet to Output on below condition
1) If "Column C" Cell value = 1 then copy that row to output sheet under row named ("1 TeraByte") from COlumn A to Column Q

2) If "Column C" Cell value = 2 then copy that row to output sheet under row named ("1 MegaByte") from COlumn A to Column Q

3) If "Column C" Cell value = 2 then copy that row to output sheet under row named ("1 TeraByte") from COlumn A to Column Q


Initially for sample data i have inputted only 5 rows.. the data can be more hence the ouptut file layout should not undergo any change.. only the rows should be added in between the Row data header & the Subtotal...

Also the Conditions are now for value = 1,2,3.. if it grows.. iw ill change the code accordingly...

Puzzled