Copying multiple sheets, I want formulas that refer between the sheets to point to the new copies. Instead they point back to the originals. With many such formulas it is hard-to-impossible to fix them all without error. A good test is to create a spreadsheet with two sheets, and create formulas between them. Then "select all sheets" and copy to a new empty spreadsheet. Then look at the links.
It's simple you must avoid the reference to the sheet being absolute. With: =$Sheet1.a1 refers to the original file, what it right it is an absolute reference. but instead using =Sheet1.a1 do as you like, again it does right not carrying the reference the the original file.