I have three unique Excel worksheets. Two of the three rely on the "parent" worksheet for referenced data. If I want to create new versions of these to make changes without impacting the originals, but keep all of the references in tact, how can I do that?

For example... if I have all three open, should I have the "child" worksheets with something like an appended "Version 2" at the end of the file name prior to saving the parent file? Or do I save the parent file first? What I don't want to have happen is any of the references in the original worksheets changing.