I have a monthly(January->December) report drawn from accounting.

In this report I'm making a final sheet with graphs etc. for departmens, It's the same sheet I'm making every month, because I can't copy it into the WB I'll get next month (Formulas keep looking at original destination-WB) - is there any way I can transfer the sheet to another WB but no formulas change?

The 9 sheets in the sent report are ALWAYS called the same, so I just need to insert my sheet as the last one, looking at data in the exact same place as always.