Prepare summary with the help of some parameters

[Pradeep Kumar Gupta]

I have a workbook and contains 4 worksheet.Requirement of VBA codes working to remove the multi conditions complicacy.

Please refer the attach file for below mentioned requirements.

1-Main input datas will be first 2 sheets i.e.'Veh.Reco and 'MB5L' only.
2-Range will be fixed i.e.cell No.C21 to C32 in the sheet 'YTD Summary'.Consider the range text in the fixed at all.
3-Now,construct the sheet 'Summary at a glance' with the following informations:-
a-Column A-No Relevance
b-Insert Column B-All the 'Mat.Group' exist in the sheet 'Veh.Reco' and col.B.
c-Insert Col.C-'Op.stock',pick up the opening datas of Mat.Group' from the sheet 'Veh.Reco but consider the range first text only.For an example, i.e.Apr-13.But,If range first text is oct'13 then op.Stock should be Oct-13 from the sheet of 'Veh.Reco' and column-C.
d-Col.D to G-As per grand total of Months,appearing in the Range.
e-Col.H and I-Should be excel formula as apply in the sheet.
f-Col.J-Grand total of model wise from sheet 'MB5L' consider the column F and I only.
g-Col.K-Difference of Col.J -col.I
h-Col.L to Q-As per grand total of Months,appearing in the Range.

Range month will be insert manual.In this example,Insert range months from Apr'13 to Mar'14.

Is this possible through VBA codes working?