linking data on different sheets and on a graph

hello all this is my first time posting. I am trying to link data from one sheet to another sheet however its not working. I have a list of names and numbers on one sheet that i would like to appear on other sheets so instead of adding and changing on all sheets I wanted some way to link them. I have tried the =Sheet1!D2 method but its not changing on the other sheets. Also the other sheets the data will be link to a chart and when the figures are changed the graph remains the same. I have a feeling there is a simple solution to this so welcome any and all assistance. Thanks

To make data from Sheet1 appear in Sheet2:

1.Select a range of empty cells in Sheet2. The range has to be the same as the area of your data in Sheet1 or bigger, otherwise this won't work.
2.With the entire range selected type = and switch to Sheet1. Select your data in Sheet1 and without leaving the cell press Shift+Ctrl+Enter.
3.If done correctly, your formula will look like this =Sheet1!C3:G11
4.Note that cell formats do not carry over. For example - if you have dates in your original data they will be transformed into numbers. A simple Cell Formatting - Date will fix this.
5.If you make changes in the original data from Sheet1, those changes will be reflected in Sheet2.
6.Any graphs created from that data will also update as you edit.

I have attached an example. Please see if it suits your needs.