How do you link cells in different Workbooks in Excel?

How to make this?
If text (Sheet1) inside of A1 fild is same as one of the names of sheets (Sheet1) than take info from that sheet (Sheet1) and from fild A2

Hi, I have 2 work sheets. On sheet 1 is a list of employees names, phone number, addresses etc and on sheet 2 is the same list but a printable version. What i need to do is say a phone number changes, rather than go to both sheets and type the phone number again, I want to link heet one - type the change and sheet 2 changes automatically. How ????

How do I reference a cell (like A1) in the source worksheet, on the server mdnas01:

\\Cmdnas01\HSC_SOLAR\Warehousing\Storage Logistics\Solar Warehousing S4 072509.xls

I have mapped server ISD$ to "J", and when I use "J" I am OK, but when I use the server name "ISD$", I am getng an error on:

=\\isd\isd$\ACC-ISD\CBAD\Team-Weekly-Updates\Testing Apps and STATUS\BHART - Test Case Matrix.xls\['V15+W7,IE8,O2010]'!K37

Could you help me?

Thanks

Dear Sir,

I want to link some rows but larger than one page in microsoft word, so can not see some rows in the sheet.
Can you help me?
Many thanks

Hi sir,I want to prepare a excel work sheet 1 with multiple rows & columns,I want the updates on other work sheet for month wise automatically when it is updated on work sheet 1.Send me visual format only for excel work sheet.

I have made a list of contacts (friends etc) in excel. Is there a way to have their phone number so I can just touch it to dial? Thank you in advance.

why the link destination worksheet was break after I added a new row at the middle of the row ?