pull required data only from report

Hi friends,

I have a report, from which i need only specific data. Not anything else. Rest of the report i dont need it.
I have attached sample report, in sheet1 i have highlited where the data is present. In sheet2 i specified 4 fields that i required. Pls help me. To set some vba code....

guys pls see both sheet1 and sheet2. i need output..no matter if its in same workbook or separate workbook. Both are fine.