Copying sheets to new workbook, but formulas are linking to old workbook

[ZeDoctor]

Hi peeps,

So i've got a code that successfully copies over tabs of my workbook to a new workbook. There is 3 sheets with formulas linking to the other 3 sheets, i'm moving all 6 in total but when I move them the formulas link back to the old workbooks data sheets and not the new sheets. How can i overcome this?

    Sheets(Array("Period y", "Period x-y", "Period y-1", "Data Input - Period y-1", _
        "Data Input - Period y", "Data Input - Period x-y", "Transport")).Select
    Sheets("Data Input - Period x-y").Activate
    Sheets(Array("Period y", "Period x-y", "Period y-1", "Data Input - Period y-1", _
        "Data Input - Period y", "Data Input - Period x-y", "Transport")).Copy