Sorting info from data sheet into separate sheets

[rajun69]

Hi Members
I have uploaded my sample excel workbook.
The instructions are in the "Header sheet" - basically,
I have info in a "data sheet" that needs to be sorted into separate sheets and give me the output into the respective sheets as shown in the "Header sheet".
Please refer to the attachment which explains the desired output.

thanking you in advance
rajun69

 

[Hui]

Have a look at the techniques applied here:

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/