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!