Excel - How to group worksheets?

[str]

I currently have 4 different excel files, which all contain 4 columns of the same information.

I was planning to have the information included on the 4 files in one excel document, but as different worksheets. However, I would like the information to keep constant with Sheet 1, ie when I add a line or change the text.

I know you can group the worksheets at the time when you are amending sheet 1 but as other people will be using this document, I would like to permanently group all the worksheets together.

Anyone know if this can be done?

 

[Diyisfun]

Register on here
http://forums.computeractive.co.uk/
The scroll down to Office Software
Post your question there, & its a brilliant place for your questions.
There are 3 or 4 brilliant people on there.