need to link main sheet to sheets with graphs and charts and have automatic updates

Hey guys,

So I have an Excel file(2007) and within the file there are 4 sheets. 1 Main sheet and 3 other sheets that contain specific charts and graphs that correlate to the Main sheet. My Goal is to set up the file so that when the user makes changes to the Main sheet, the graphs and charts in the other 3 sheets AUTOMATICALLY update accordingly rather than someone changing every item.

As of now I have created a 5th sheet which contains the data and acts as a middle man so It looks like this

MAIN SHEET <--> Datasheet --> Sheet1,2,3

Im not really sure If Im going about this the right way and which formulas to use in order to update the other sheets. Ive tried searching many forums but cant find anything similar to what I am trying to do.

Does anyone know which formulas to look at or If im going about this the right way. Thanks!