Structured references between worksheets
 

Can you use structured references between worksheets? I have 2 excel tables
in separate worksheets. One table needs to reference data in column in
another worksheet. Everytime I put in = in cell of table 1 and go to table 2
(on tther sheet) I get the usual 'SHeetname'! How can I replace this with
Table name and column name as is done automatically if in same table?

AND.. what if I want an offset. That is the reference to a cell in other
worksheet is not in exact same row but off by 1 or 2 rows?