Excel workbook links

[Tuck]

Is there a way to link a specific worksheet in a workbook to a different
workbook? I have a summary workbook that links to separate job workbook. Each
job workbook has multiple worksheets. I want the first worksheet in each job
workbook to be linked to a summary workbook. The summary workbook will have a
worksheet for each linked job first worksheet. Does that make sense?

 

[Sheeloo]

You want to link all the cells in a worksheet to cells in another worksheet
in another workbook?

Select the source range, say A1:Z100, Copy the range
Go to the cell A1 in your destination sheet and choose Edit->Paste
Special->Paste Link