Copying change in Masterlist worksheet in alphabetically Order

Hi,

I have a list of data in multiple worksheets for example in attached workbook with name L,A,M,P.The data starts in those columns from C6 & D6.I have removed all unnecessary data above C6,D6 and towards right & left.

There is one 'Masterlist(Existing)' worksheet.In this worksheet in A & B column there is summary list.

Now,What I want is that I want to get the those data from worksheet L,A,M,P from C6 & D6 column each worksheet that are not available in A & B column of Masterlist (Existing).

I have shown my expected desired result in worksheet "Masterlist-Required".I have further shown the changing part by highlighting which infact is to alphabetical order.

I do not like to overwrite 'Masterlist(Existing)' worksheet and would prefer the change part only.If there is alphanumeric change in 4 worksheet in D column then that can be ignored as numbers are already in C column of each worksheet that would easily match with 'Masterlist(Existing)' in A column.

Why shall be
Ace Ltd
inserted between
A G
A One

it is not an alphabetic order

This proposal employs Get & Transform (aka: Power Query) which comes standard with versions 2016 and newer.
1. Convert the ranges on the Masterlist, L, A, M and P sheets into Excel tables (Ctrl + t)
2. From the Data tab select Get Data > From Other Sources > Blank Query
3. Replace the preset code in the Advanced Editor with the following:

Please Login or Register  to view this content.

4. Under Query settings > properties > name type "CombinedList"
5. When the table is placed on a sheet (i.e. Masterlist-Required) select the filter button in the Name cell and sort ascending
6. Select the name column and Remove Duplicates (Data tab)
Let us know if you have any questions.