List unique values corresponding to certain criteria from across multiple sheets

In the example file attached I have multiple sheets containing 3 lists each. The first 2 lists on each sheet are combined in the 3rd by using a formula devised by one of the clever people on this forum.

If a value is present in the second list but not in the first, I have manually marked it as a "New entry" - ideally this would be automated.

What I want to do next is filter out all the new entries from across all the sheets and combine them in a separate list containing just the unique values.

Can anybody help, please?

Andre

Thanks for that part, the harder part though is constructing a list of all the values that correspond to the "New" criterion. This list should only contain the unique values.

In the file under the "New entries" tab, D3:D9 shows the desired output values. This is a much simplified version of what I actually need to do this for. In my actual workbook (containing many sheets) there are numeric values that correspond to each list (omitted in the example file), which I then sum. This gives me the quantities that correspond to the entries in each second list which do not appear in the first list of every sheet, for all the sheets.

Maybe

Put in New Entry Sheet D3 and copied down:

=IFERROR(INDEX('Sheet 1'!$E$4:$E$25,SMALL(IF('Sheet 1'!$F$4:$F$25="New Entry",ROW('Sheet 1'!$E$4:$E$25)-ROW('Sheet 1'!$E$4)+1),ROWS($A$1:A1))),IFERROR(INDEX('Sheet 2'!$E$4:$E$25,SMALL(IF('Sheet 2'!$F$4:$F$25="New Entry",ROW('Sheet 2'!$E$4:$E$25)-ROW('Sheet 2'!$E$4)+1),ROWS($A$1:A1)-COUNTIF('Sheet 1'!$F$4:$F$25,"New Entry"))),""))

Array Formula, you need to confirm press CTRL-SHIFT-ENTER button together and copied down as necessary

Thank you so much!

You're welcome, thanks for feedback