VBA code to pull data from one worksheet to another

[hrayani]

Hello Friends,
I need a VBA code for the following... there is some data in the sheet "DATABASE"

FIRST PART
I want all the above mentioned data for all 3 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from ROW 11 & COLUMN B:D
1) with removing duplicates keeping in mind all 3 columns
2) with sorted data as below
orders_qualitys = Order:=xlAscending
then by orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"

SECOND PART
I want all the above mentioned data for 2 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from LOOK AT LAST USED ROW FROM FIRST PART THEN LEAVE 5 ROWS EMPTY & COLUMN B & COLUMN D (here column C will remain empty)
1) with removing duplicates keeping in mind 2 columns
2) with sorted data as below
orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"

updatequalityarticleunitcodes.xlsm
	A	B	C
1	Bed Set	CVC Renforce - 90 Gsm	Set(s)
2	Bed Set	CVC Renforce - 90 Gsm	Set(s)
3	Bed Set	CVC Renforce - 90 Gsm	Set(s)
4	Side Pillow	CVC Renforce - 90 Gsm	Pc(s)
5	Pillow Pair	CVC Renforce - 90 Gsm	Pair(s)
6	Terry Towel	CTN 400 Gsm PUNCH	Pc(s)
7	Terry Towel	CTN 400 Gsm PUNCH	Pc(s)
8	Bed Set	CTN Renforce - 115 Gsm	Set(s)
9	Pillow Pc	CTN Renforce - 115 Gsm	Pc(s)
10	Duvet Cover	CTN Renforce - 115 Gsm	Pc(s)
11	Fitted Sheet	Microfiber Interlock - 135 Gsm	Pc(s)
12	Bed Set	CVC Renforce - 90 Gsm	Set(s)
13	Bed Set	CVC Renforce - 90 Gsm	Set(s)
14	Bed Set	CVC Renforce - 90 Gsm	Set(s)
15	Bed Set	CTN Renforce - 115 Gsm	Set(s)
16	Bed Set	CTN Renforce - 115 Gsm	Set(s)
17	Bed Set	CTN Renforce - 115 Gsm	Set(s)
18	Pillow Pair	CTN Renforce - 115 Gsm	Pair(s)
19	Side Pillow	CTN Renforce - 115 Gsm	Pc(s)
20	Fitted Sheet	Combed Jersey 135 GSM	Pc(s)
21	Fitted Sheet	CTN Jersey - 140 Gsm	Pc(s)
22	Fitted Sheet	CTN Jersey - 140 Gsm	Pc(s)
23	Bed Set	CTN Renforce - 115 Gsm	Set(s)
DATABASE

updatequalityarticleunitcodes.xlsm
	B	C	D
11	Fitted Sheet	Combed Jersey 135 GSM	Pc(s)
12	Terry Towel	CTN 400 Gsm PUNCH	Pc(s)
13	Fitted Sheet	CTN Jersey - 140 Gsm	Pc(s)
14	Bed Set	CTN Renforce - 115 Gsm	Set(s)
15	Duvet Cover	CTN Renforce - 115 Gsm	Pc(s)
16	Pillow Pair	CTN Renforce - 115 Gsm	Pair(s)
17	Pillow Pc	CTN Renforce - 115 Gsm	Pc(s)
18	Side Pillow	CTN Renforce - 115 Gsm	Pc(s)
19	Bed Set	CVC Renforce - 90 Gsm	Set(s)
20	Pillow Pair	CVC Renforce - 90 Gsm	Pair(s)
21	Side Pillow	CVC Renforce - 90 Gsm	Pc(s)
22	Fitted Sheet	Microfiber Interlock - 135 Gsm	Pc(s)
23
24
25
26
27
28	Bed Set		Set(s)
29	Duvet Cover		Pc(s)
30	Fitted Sheet		Pc(s)
31	Pillow Pair		Pair(s)
32	Pillow Pc		Pc(s)
33	Side Pillow		Pc(s)
34	Terry Towel		Pc(s)
Supplier Wise

updatequalityarticleunitcodes.xlsm
	B	C	D
11	Fitted Sheet	Combed Jersey 135 GSM	Pc(s)
12	Terry Towel	CTN 400 Gsm PUNCH	Pc(s)
13	Fitted Sheet	CTN Jersey - 140 Gsm	Pc(s)
14	Bed Set	CTN Renforce - 115 Gsm	Set(s)
15	Duvet Cover	CTN Renforce - 115 Gsm	Pc(s)
16	Pillow Pair	CTN Renforce - 115 Gsm	Pair(s)
17	Pillow Pc	CTN Renforce - 115 Gsm	Pc(s)
18	Side Pillow	CTN Renforce - 115 Gsm	Pc(s)
19	Bed Set	CVC Renforce - 90 Gsm	Set(s)
20	Pillow Pair	CVC Renforce - 90 Gsm	Pair(s)
21	Side Pillow	CVC Renforce - 90 Gsm	Pc(s)
22	Fitted Sheet	Microfiber Interlock - 135 Gsm	Pc(s)
23
24
25
26
27
28	Bed Set		Set(s)
29	Duvet Cover		Pc(s)
30	Fitted Sheet		Pc(s)
31	Pillow Pair		Pair(s)
32	Pillow Pc		Pc(s)
33	Side Pillow		Pc(s)
34	Terry Towel		Pc(s)
Year Wise