Several years ago I had a spreadsheet (I think it was Lotus) where I had a
cell on one sheet that was automatically reflected on several other sheets.
For the life of me I cannot figure out how I did it in Lotus or how to do it
here in Excel 2007. I'm sure it's really simple and that I'm just a little
too dense. Can anyone point me in the right direction?

For instance, I might want the contents of sheet 1 row 3, column 5 to be
reflected on sheets 2, through 5 at row 3 column 5. How can I do this?

Thanks,
Michael