12 month stock movement ONE CLICK

Have data on sheet 1 , I want sheet2 automated ,
I want the movement of a particular code that I will paste on a2 of sheet2
it should fetch totals from sheet 1, formula required on sheet2 cell c2 that should
be draggable right and downwards

drag right to fill what is sold on the rest of the months , drag down to fill sold for other code

You have to wright all code in sheet2
and use Vlookup function for column Discription
and in column '1','2','3'.... use sumifs function.

Sumif I know , but I have to do manually highlight the range once , is there not no sumif to combine 1 to 1 , 2 to 2 , 3 to 3 and so on

I have set the raw data to months horizontal and vertical , thus I will do the formula on each row once only using sumif

horizontal data and not vertical and then sumif formula 12 times , one time effort drag down to work for all codes