Connecting cells in different sheets

[MDBC]

Name	code		Size in cm	Weight in kg	Age	Gender M/f	kg/cm	size/age	weight/age
Persons
Andrew Black	P001		180​	82​	23​	M	0.46​	7.83​	3.57​
Sarah Jones	P002		169​	71​	32​	F	0.42​	5.28​	2.22​
Tim Bradford	P003		175​	71​	45​	M	0.41​	3.89​	1.58​
Julie Clark	P004		172​	60​	45​	F	0.35​	3.82​	1.33​
Simon Little	P005		175​	92​	19​	M	0.53​	9.21​	4.84​
Pets
Cat Tee	A001		20​	8​	6​	M	0.40​	3.33​	1.33​
Dog Gie	A002		15​	9​	9​	M	0.60​	1.67​	1.00​
Hor Sie	A003		130​	25​	11​	F	0.19​	11.82​	2.27​
Cat Tle	A004		10​	5​	10​	F	0.50​	1.00​	0.50​
Dog Gy	A005		25​	11​	4​	M	0.44​	6.25​	2.75​
How can I link column A with column B?
I would like to use the codes in column B in different sheets.
For example if I type B5, I would like cells in other workshheets to automatically
fill in the corresponding data from D5, E5, F5, G5, H5, I5 and J5
Ps What would I need to do if I insert/delete 1 more person or pet so that the formulas
get inserted/deleted automatically as well
Thank a lot!!

 

[Fluff]

Cross posted Challenge: connecting cells in different sheets

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[MDBC]

Cross posting answer, so far.

Challenge: connecting cells in different sheets

Hi all, anybody know how I can link column A with column B? I would like to use the codes in column B in different sheets. For example if I type B5, I would like cells in other workshheets to automatically fill in the corresponding data from D5, E5, F5, G5, H5, I5 and J5 Ps...

www.excelguru.ca

Answer: =INDEX(Sheet1!D:D,MATCH($B2,Sheet1!$B:$B,0))