I have 5 sheets A,B,C,D,E in a work book X & each of B,C,D and E have links
to cells in sheet A.
I need a macro to copy workbook X to to a new workbook Y using the same
sheetnames as in X but for the new A,B,C,D & E sheets in Y to have all links
removed.