how to copy a workbook from other workbook with 10 worksheets with lot of
macros.

Last year our company had error with these kind of copied macros files.

Please anyone help me to do it in the correct way.

Thanks