Link between multiple excel tables and multiple tabs

Hello

I have created an assembly of a railing and want to make a "smart and fast" drawing.

I first created a first tab with a calculation basis via an excel table (ref A and B)

In a second tab, a second table that includes certain elements  of the calculation table. (ref C).

First problem:

When I change my information on my calculation table (ref B) - The update is not done on the second one (ref C) unless I double click on it.

Operation not too restrictive if I only had one!

Second problem:

By dint of double clicking, the link between the tables is lost (ref D) and shows me 0s everywhere.

 

Is there a "simpler" way to make these links between paintings or maybe I forgot to do something?

 

 


gc.pdf