Automaticly fill cells on differnt pages

[KPGStar]

I have a worksheet with two pages and I need to have the data from some cells appear on the both pages. Is there a way to have the data automaticly appear on the second page when the cell is filled. The data is all simple text. Getting tired of copy/paste between the two pages.

Example of what I want done. Have the contents from the cell, page1 column 4 row 5 appear in the cell page2 column 3 row6.
Thank-you

[sktneer]

Try this.......
On sheet2

Please Login or Register  to view this content.

More accurately...

Please Login or Register  to view this content.

[KPGStar]

Not working. The formula just shows up in the cell instead of the content from the copied cell.

[KPGStar]

This is an example of the original formula that was in use. =IF(FLOORS!$E$9>0,FLOORS!$E$9,"") It works off and on, with the FLOORS sheets having to be saved, before teh cell contents are copied to the other sheet.

[KPGStar]

Working .. now I need it to appear on the sheet without having to save my work first.