Excel question

Need help with Excel cell reference formula problem ..... I want to show one cell value to another cell and one cell value from another sheet ....can you help here please.

Carieer #Client NameAddress Eligibility FamilyEligibility AnalystIMAMclient call happenShared Address IDFamily Type

1001ABCYesHome1,2

1002XYZYesOffice1,2

1003LifeYesInternation1,3

1004HospYesHome4

1. How to get column I, J, K  valuesto  show in C,D ,E

2. How to get value of column F (EA), G, H from EC sheet