Sharepoint WorkBooks

I currently have multiple Excel Workbooks that are at multiple locations throughout my area that feed back to my master workbook. I have them all linked. I have to do this monthly so I have to create new month workbooks. The problem is when i save a copy of the current workbooks it starts changing this months information. All I want to do is copy all the information on the workbooks, but change the date without it updating anything else.