How can I copy the raw data from my main worksheet from each month without
coping the links?

Copy - Paste Special - Values

How can I compile each month to create the graphs for trend purposes?

Copy the data from the separate sheets, paste values onto the summary
worksheet, and the charts linked to the summary worksheet will update.

Also creating multiple graphs.

Don't know what you're asking.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______