Hi guys,
new enough to macro's. having trouble writing a macro for copying a sheet.
Data is entered into the data sheet and each month a new sheet with graph is produced by the macro with the option of naming it.

I can't figure out how to have the source data for each new sheet/chart reference the data in the data sheet without the previous charts source data changing as a result. I essentially need to create a new chart with frozen data and be able to name the sheet. Any suggestions greatly appreciated.