My function is checking based on Work Sheet Name, I need to change this function

Team,

I have a requirement to show the Unique value of column B in all the sheets for that I have a written a function

After I got the Unique Values I need to compare those Unique Value with Other Column in each Sheet let say Column F Which has PASS OR FAIL and we should get the Count for those Unique Values Which has "FAIL" in Column F.

Basically I need the Count of Each Value in Unique Sheet Column A based on Other Sheets Column B and Column F

I have written the code like this

1) I Wrote a Code the generate the Unique Values which are generated in Column A in UNIQUE SHEET

Please Login or Register  to view this content.

2) Using the Column A of UNIQUE SHEET I am trying to search Column F in each Sheet which has FAIL and I need the COUNT of each Unique Value.

The Function I have written is comparing with sheet and not with Column B in each sheet.

Please Login or Register  to view this content.

I have attached the file - I Need the Count in Column C in Unique Sheet which will be at the Last.

Any help is appreciated!

Thanks!
Kiran