Create macro to select only the required data and put a pivot

Hi,

I've a data which contains unwanted details like Run date, Time, Group, etc; and columns which are blank. Can anyone help me to create a Macro which gives only the data which is required other than these details and create a pivot for a check make my job easier?

My requirements;

1) the raw data is in the 1st tab and i want the details as ,WBS Element ( eg. NL1-CNxxx.xx.xx.xx ); Descriptions ( L2 Service Desk ); Emp ID ( 218xxxx ); Emp Name ( MOHD, ALI ); Date & hours [all the required details are colored in the file] in the next sheet giving a name as 'Result' .

2) The 3rd tab should have a pivot of the 2nd tab so that i can have a check whether the raw data is matching with the result (i.e. 'Result' tab) given by the macro.

Please find the below link where the data is saved.

https://www.box.com/s/r49yr1hib2d3ljun0dy0

Waiting for the earliest reply.

Regards,
IM