Copying sheets with formulas

[tpedry]

I am trying to copy a soccer position lineup sheet several times so that I can have a fresh copy for each game, however, whenever I do this, the formulas always points back to the original sheet and I have to repoint each position. This defeats using this spreadsheet for saving time and simplicity.

See attached.

Thank you

Tim

[Richard Buttrey]

Which formulae and how are you doing the copy?