Need to Show only the Common Rows in Summary Sheet

[Kandavalli.Kiran]

Team,

Please suggest me on my below requirement.

1) In my file I have 3 sheets.
2) In each sheet I will have three columns (Table Name, Test Case, RCA)
3) I need a macro which show the Duplicate rows in all the Sheets in a Separate Summary Sheet

The macro should create a separate Summary sheet with 4 columns (Table Name, Test Case, RCA, PATH) to show the Common Rows in all the existing sheets.

PATH Column is nothing but the Sheet Names if that Particular TABLE NAME and TEST CASE NAME exists.

Macro should apply condition based on Column A and Column B only and not based on Column C

Summary Sheet Example

Table Name	Test Case Name	RCA	PATH
Table1	Test Case1	In Progress	IT2, ST2

I already wrote a code for this but it is throwing me an error, can someone check this for me please.

Thanks!
Kiran