Hello everyone!

I'd like to apologise if this issue has already been discussed previously, but despite searching high and low on Google and on this forum, I couldn't find any answer for my problem.

What I am trying to do is as follow:

I'd like to get a cell that displays the same value across all sheets, so that if I put a value in - for example - D3 in Sheet1, it'll display the same value in D3 in Sheet2 et Sheet3, but if I edit D3 in Sheet2, it'll also change the value of D3 in Sheet1 and Sheet3, and so on.

(Basically, some people and I have to manage an inventory where products are separated in different sheets, and I'd like them to be able to put the last time they changed something in the inventory, i.e "Last edited on 5/17/14". And I'd like this date to be displayed on all the sheets, without having to edit the "last time edited" date on all the sheets, nor having to go back to Sheet1 to see the date).

I'm quite the newbie at Excel, I tried some things, but I really don't know what tool I should use to do this.


Thanks a ton in advance for helping me out!

A-Z