How to compare multiple tables in Google Sheets?

Question

Google Sheets

Good afternoon.
There is a database consisting of more than 7,000 unique positions (sales by stores), using the filter formula, the database is divided into 30 tabs (for each partner, the filter is set to the name of the store).
It is necessary to understand which positions from the common base were not included in the filter.

VLOOKUP tried, but after 7000 operations the table hangs.

How can this be done without macros?
Thank you.

Answer 1

If the task is "one-time", then you can do it not in Google spreadsheets, but somewhere else.
And I see no reason not to use scripts.
1) Collect all data in one sheet
2) Make difference between two arrays (original and new)
Here is a function that returns the "difference" of arrays (1 row or 1 column)

function arraysDiff(arr1, arr2) {
    arr1 = arr1.flat(2);
    arr2 = arr2.flat(2);
  
    arr1 = arr1.filter(el=>arr2.indexOf(el)===-1);
    arr1 = arr1.map(el=>[el]);
  
  return arr1;
}