I have 5 tabs with data a lot of data in each tab. Each tab represents a product and each tab has the same data output in the same cell. ie – part model # is always C1, part volume is always in cell W3, part weight is always D4, etc.

I want to have a summary sheet where some of the info is displayed. however, I want to link it in a way that the data can be driven by the model # cell.

So if I create a new tab with data and the tab name is “part X”. I would like to link cell C3 from the new “part X” tab manually (='part X'!$C$3). Tab names may not be the same as model #. Then the part volume and weights should be driven in the by and equation where “part X” is pulled from the formula ='part X'!$C$3 and then turned into ='part X'!$W$3 or ='part X'!$D$4 in the corresponding cells. Anyway this can be done?

(Result)
Model // Vol // Weight
A // 1 // 4
B // 2 // 5
C // 3 // 6
D // 7 // 8

(formula)
Model // Vol // Weight
='4f8'!$C$3 // ='4f8'!$W$3 // ='4f8'!$D$4
='XTH-21'!$C$3 // ='XTH-21'!$W$3 // ='XTH-21'!$D$4
='1506'!$C$3 // ='1506'!$W$3 // ='1506'!$D$4
='part x'!$C$3 // ='**variable**'!$W$3 // ='**variable**'!$D$4