Hi Davis,

Is this logic will work for 40 Sheets. as per my below example. please Suggest and thanks for your help!

For Example if I have two sheets, I should not manually enter Sheet 1 and Sheet 2 in the Code it is to be automated in the Code. Can you please help me on this.

I need to Create Final sheet as in the Third Table.

In Final Sheet I need to remove the duplicate and show in First Column and Number of FAIL in second Column and Number of PASS in Third Column.

Please Note that the logic should work automatically even if the Client add a New sheet or delete the Existing Sheet. Please help me on this.

Shee1

Table Name Test Case Test Result
ABC ABC_Test Case 1 PASS
ABC ABC_Test Case 2 FAIL
ABC ABC_Test Case 3 FAIL
XYZ XYZ_Test Case 1 FAIL
XYZ XYZ_Test Case 2 FAIL
CDE CDE_Test Case 1 PASS
CDE CDE_Test Case 2 PASS

Sheet 2

Table Name Test Case Test Result
CCC CCC_Test Case 1 PASS
CCC CCC_Test Case 2 FAIL
DDD DDD_Test Case 1 FAIL
DDD DDD_Test Case 2 PASS
DDD DDD_Test Case 3 FAIL
DDD DDD_Test Case 4 FAIL

Final Sheet Should be created as below

Table Name COUNT OF FAILS COUNT OF PASS
ABC 2 1
XYZ 2 0
CDE 0 2
CCC 1 1
DDD 3 1