Base on first sheet ,second sheet data auto arrange.

Here i have attached my sample sheet.My requirement is my worksheet first sheet data daily changing.base on that new data second sheet should auto fill.

Second sheet
column "A" - first sheet all the customer names(column "C") should display one by from cell A5 to down

column "B" - Column "A" customer's total cone values pick from first sheet & display as a category wise.(first sheet column "J" values)

column "D" - first sheet all the quality types (column "G") should display one by from cell D5 to down

column "E" - Column "D" all the quality type values pick from first sheet & display as a category wise.(first sheet column "J" values)

column "G6" - First sheet column "G" SSP & Column "H" 40/2 then, column "L" all the values should total & display..


This is my office document & pls help me to do this.if any body can help, it's a big help to me & it will reduce my office workload,thanks in advance..

mahju@ thanks for the help.but my data not fix.so it's not help to me..