Hi,
Can you please tell how many rows of data you have in each tab. It will depend on number of records, tabs and complexity of data to compare. Can you please share a sample data file to look into. But anyway I can provide you outcome data file next day of wining this bid. I've analyst background and I do use lot of excels formulas like this. Please see my private message as well.
Regards,
Monika