Sort data in rows and columns that is a mess

[Sharid]

I have a list of data, it come in a mess and it takes forever to sort out with filters. The data comes like this

A	B	C
10	%John	ADD:1 My Address
10	#Jane	1 My Address
15	%bob%	ADD: 1 My Address
5	#peter?	ADD: 1 My Address
10	ADD: 11 My Address	#Joe
10	#Jane	ADDS: 11 My Address
2	peter	#Steve
10	ADDS:10 My Address	#Steve

<tbody>
</tbody>

I need it to Keep All the rows

With "10" then
the rows with 10 + "#"
and then rows with 10,# + "ADD" or "ADDS" in them

The code is to then clears all the other rows and deletes all the BLANK and duplicate rows


Finally, It also needs to sort the names in Column B and Address in Column C. So the end result will look like this

End Result

A	B	C
		ADD:1 My Address
10	#Jane
10	#Jane	ADD: 11 My Address
10	#Joe	ADD: 11 My Address
10	#Steve
10	#Steve	ADDS:10 My Address

<tbody>
</tbody>

The code has ignored row with 15 and 5 above as they did not have the number 10 in them even though they had "#" + "ADD"

Can anyone please help.