Carl,

My guess is that you are dealing with very large workbook, and many
sheets with complex formulas ...
Therefore building Tables would be rather difficult and extremely
cumbersome ...
Let me dig around to find out potential solutions

Meanwhile a real guru might come up with a brilliant idea ...

Cheers
Carim