How to count cell in multiple Excel sheet

[callsidd]

Hi guys,

I have 83 excel files and each file contains two sheet name "Missing with contact details" & "Re-registered or registered". I need to only count the data that is available in both sheet, how can i do that when there are different 83 excel files?

need a quick response pls.

thanks