Linking whole worksheets

[ScottyWm]

I searched but didn't even find anything that looked like my question. I have one workbook where I want to link a whole worksheet to a whole worksheet in a different workbook. There will be about 20 tabs like this, each linked to a different workbook.

I can link it just by the normal way with the cells in the worksheets linked. But I thought there must be a more elegant way to do this where you could maybe just put some code on the VBA Object for the particular sheet? Too bad you couldn't just right click the sheet tab and paste a link there.

Any ideas?

TIA

 

[Smitty]

You can Copy-->Edit-->Paste Special-->Paste Link.

But linking massive amounts of data can be really inefficient.

 

[ScottyWm]

Yeah, that's not what I was looking for. That pastes links in each cell - what I would call a normal link.

I thought there might be a way to link using VBA where you could just make "Book1 Sheet1" = "Book2 Sheet1" or something.