Count differences in Values between 2 columns in a table, across multiple worksheets

Hi Everyone,

I'm hoping someone can help me out with an issue I'm having;

I have a workbook which has the same table repeated on 10 sheets, the data in each is different.

I currently use INDIRECT with a tab list range to create a sumproduct countifs to count various factors across all tables and this works perfectly, however I have hit a roadblock.

I need to count the number of differences between 2 columns in each table, I could construct 10 countifs and add them all together but I would rather use the approach above as if I need to add or remove sheets in the future it will be easier to amend.

Here is an example of my current formula:

=SUMPRODUCT(COUNTIFS(INDIRECT(""&TabList&"[Logistics Service Provider]"),"<>Supplier DDP",INDIRECT(""&TabList&"[Reason Code]"),"<>4. Incorrectly Reported by Region",INDIRECT(""&TabList&"[Delivered Time]"),<>INDIRECT(""&TabList&"[Booked Time]")))

The last element of the above countifs is the one I am having trouble with, I need to count the instances that appear in Delivered Time that don't match with corresponding value in Booked Time.

Any help would be appreciated