A2 B2 C2 D2 E2 F2
123 1/01/01 1/02/01 1/03/05 1/04/05 1

a2= unit number
b2-e2= dates the unit moved
f2= what cycle its on

So im trying to get the sheet to link to another worksheet, but not lose the
info or the link when I start the next cycle.
eg; the above example is now done with cycle 1 and is linked to another
sheet, cycle 2 is about to start, so Im going to erase the dates. Is there
anyway of Excel saving cycle 1's information in the linked worksheet?