Hi,

There is a contradiction here. You say:

I am trying to remove sheets ...and Postcodes by DA
but also

I need sheet Route Allocation to find the data direct from Postcode by DA.
Please clarify. You can't both remove a sheet and also use the data therein.

Please confirm which is original data and which are the results and explain with an example or two how you get from one to the other.
You also imply there are duplicate names although I can't see any. Make sure that any examples you offer cover the situations where duplicate values are a factor.