Consolidating data from different workbooks to a master template

[Nduduzo]

Hi.

I want to consolidate worksheets from different workbooks but the challenge is that the data in the worksheets of the different workbooks is not the same yet I want to summarize only the data that is the same within the worksheets of the different workbooks.

what can I do to achieve this? Please help!

 

[texasalynn]

post examples of the "same" data and how it is to be consolidated