Macro to reformat worksheet into another format

Hi,

I have an input worksheet in the format "Work Item Status Expanded" worksheet.I am trying to create a macro to reformat the worksheet into the format mentioned in "Desired format" worksheet.
The cells in both the worksheets have been marked in Yellow and grey to highlight the input fields.

I am novice in VBA and hence any help in this macro in this regard would be highly appreciated.

Thanks,
Vivek

Are you saying you just want the data rearranged on "Desired format" sheet?

Hi,

Yes,the data just needs to be rearranged as per the layout in the desired format worksheet.

Thanks,
Vivek