Can you use table structured references with a 3D reference Same column through multiple tables.

Hi Debs_au 

Given that your tables appear to be consistenly named (Table01, Table02...Table20) with exactly the same columns it would be pretty straightforward to consolidate them all as a big Table with Power Query. You would then perform your XLOOKUP on that big Table

Is this an option for you? Do you need a sample?

Note: if you keep the same naming convention for your tables, the query can auto. pick any additional table, i.e. Table21, Table25...