Link Three Sheets

[abshake]

I am using Excel 2003.

I want to link three spreadsheets to my main destination sheet. I can just do a paste special and I will get the data in my destination sheet. But if other user insert rows in those three sheets, I cannot get that data automatically. I have to do it manually. Can anybody help me in this regard ?

Thanks,
AB

[Lotus123]

Linking in Excel is fairly user friendly and can be done with the following steps:

1) Open your "master" spreadsheet.
2) Open one of the "other" sheets. Figure out what cell in this sheet you want linked to the "master" sheet. For example purposes I will choose cell C5.
3) Figure out where you want the cell chosen in step 2 to appear in the "master" spreadsheet. For example purposes I'll say cell A1.
4) Select cell A1 in the "master" spreadsheet.
5) Type an "=" sign. This will begin a new formula in Excel. Without pressing enter, change to the "other" spreadsheet and click cell C5. You will notice the formula bar should now read something similar to the following: ='Otherspreadsheetname'!$C$5
6) Press enter.
7) There should now be a value in cell A1 of the "master" spreadsheet that is linked directly to cell C5 of the "other" spreadsheet. If you change the value of cell C5 in the "other" spreadsheet then it will automatically update in the "master" spreadsheet (as long as both files are open).