For five weeks I have been writing Macros to do various functions

I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.

All four of these Workbooks and all my Macros worked great in my Test
Directory

I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
final time.
All my Macros (3000 Lines) were destroyed!!!!

Why did it destroy the Macros in my other three Workbooks.

This never happened with IBM Lotus, why is it happening with Microsoft.

Explanation Please

Thanks

J.Q.