Hi Need help quickly

i have a spread sheet setup with 40 separate sheets which are all identical except for the data that is entered. i would now like to add a graph to all sheets that will work based on the different data that may be stored in these charts. i have 800 separate sheets divided into 20 workbooks i do not want to have to go into each sheet separately and manually put a graph in it will take to long.

so basically i want to make a spreadsheet that is master to about 40 sheets so that when i change the format or add new fields and graphs they appear on the other 40 sheets without erasing the data that is saved on those sheets themselves. like a master spreadsheet that can be edited to change the other 30 or so without loosing the separate data on the 30 sheets.

cheers. Fred (who needs help)