Linking/Embedding Worksheet to Another Workbook

[Orthodoxyn]

Hi,
I'm looking to link/embed a summary sheet from one work book to be displayed in another.
When i update this summary sheet i wish for it to update the linked work book.

Is anyone able to help with a guide or point me in the right direction?

Thanks

[:) Sixthsense :)]

Not sure what formula you are using or just using =workbookcellreference?

[Orthodoxyn]

I am unsure of what formula to use.
I have tried the one above but haven't had any success. I need to link entire sheets within another workbook. Not sure if that helps?
Thanks for your help though

[:) Sixthsense :)]

You can... but linking how many cells in each sheets is another question! And how many sheets? Just trying to show the data from the source or going to do calculation with the source?

[Orthodoxyn]

The work book will contain one sheet from another workbook. If possible i need all the information copied across, showing the data from the source.
If when i come to update the original sheet would it be possible to set it up to automatically update the sheet copied across?

[:) Sixthsense :)]

Just do a google search with a keyword like

how to link excel workbooks with formula

you will get lot of informative websites which describe the process in detail...

[Orthodoxyn]

Thanks for your help.
The formula works but when testing it on a google drive system it doesn't update the main summary sheet.
Oh well back to the drawing board.

[:) Sixthsense :)]

Sorry to say that I don't know anything about google drive and hope someone will help you...