Mirror spreadsheets

How can I mirror a spreadsheet so that it will look like another without switching back and forth between the 4 sheets pressing = and then clicking the same cell in the other spreadsheet?

What I have is 4 spreadsheets that are worked on by different people at the same time. What I want to create is 1 workbook with 4 tabs that just show the information being put in the 4 spreadsheets. What would really be cool is if there was a way to see the information being put into one of the spreadsheets in real time from the workbook with the 4 tabs!

this is a pretty simple solution actually.

Ok, open a new book.

Open the 1st sheet you want mirrored.

Then right click on it, and copy it to your new workbook.

Repeat for each sheet.

Then, in your new workbook, simply link the cells to the original sheets.

Ta Da!

thats correct, but if someone adds a row or moves something.... it wouldn't work anymore

I bet there is a way... but I really don't know how

do you want them to add a row?

just protect the book.

Yes, they will always delete and add rows... It's a little deeper than you thought ehh?

ok, so i think i understand what you are looking for then. you always have to go with the simplest answer first. you want an exact "mirror" not a link.

the simplest way, in my opinion, would be to try and formalize the processes that the others are doing...

do you have an example of one of these sheets they will be using to get some ideas flowing?

otherwise, you'd need some sort of copy and paste macro that could update each row, over and over, within certain limits, or cycle through it every now and then. i'm just not sure how you'd keep some formating with this.

just my thoughts, any others?

take a look at the attached sample.
you can add a few rows to one of the sheets {robert, sally, bob or jill) and on the master summary you will get warning / reminder to hit update button.
Let me know if this works for you.
This workbook will update and copy four individual sheets to master sheets.
Master sheets are labeled M-Robert, M-Sally etc.
You can have the master sheets and individual sheets on different workbooks.
You will have to update the sheets' names in the macro.
modytrane