Copy data from one cell and paste in another sheet

Hi Everyone,

I have an excel sheet (2010) which has raw data. I want to copy only certain bits of data into another sheet segregating the data.

I have attached the sample file

The data has to be taken from Raw data and copied in the sheet Macro-data as per the required fields until last empty cell.

Need 2 such macros for different types of data.

Raw data to be copied in the sheet Macro-data ---------> 1st Macro copy paste
Raw data1 and copied in the sheet Macro-data1 -------> 2nd Macro copy paste

Regards

Umesh