Assume I am speaking very slowly and deliberately:
"Do not trust confidential information to be secured in an Excel workbook that is accessed by multiple users."

Find another way to gather and consolidate your information. If you must use Excel, engage a competent, professional Excel consultant who will help you get what you need without using a shared workbook.