Extracting desired data from a list when the Unwanted list is provided

Extracting desired data from a list when the Unwanted list is provided..

This query is somewhat similar to the link provided below answered by Teethless mama.

HTML Code: 

I have two lists :
1. The Total list - This list has the names of all the Sheets or Tabs added in the Workbook.

I have defined a Name -Sheets
[ Sheets - SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")&T(NOW()) ]

By virtue of this formula, I get the names of any sheets which are added in the workbook, however I would need the Names of only some selective sheets and some names would not be required for any practical purposes.

Now I plan to have the Names of all the Sheets that I dont want in a second list called as Unwanted List.

Sr.No. Sheet Names Unwanted Sheet Names Desired List
1 Sheet1 Sheet 1 A
2 A Sheet 3 B
3 Sheet3 Sheet 5 C
4 B Sheet 7 D
5 Sheet5 Sheet 9
6 C
7 Sheet7
8 D
9 Sheet9

In the above list, the Desire List should show only A,B,C,D which is remainder from the Sheet Names -Unwanted Sheet Names.

I want a solution preferably In MS Excel formulas....

Bump........

Bump...Please someone ....

Hi
here is a macro which lists sheet names and sorts them into desired and undesired based on if "sheet" is present in its name or not.try it and let me know
Ravi