Case Management Excel Sheet

Hello there everybody,

I work in a securities exchange and I'm developing an excel sheet that may help as a simple case management system to register and follow the updates of different fraud cases.

as it is with the attached excel sheet, I need this simple case management system to do the following:

1) show the company name, investor(s), security code, what the case is about, the decision that has been made, and few general information about the case.

2) give me the ability to search for cases in the database on the bases of the first four columns, (company name, investor name, security, the case)

I believe this needs some sort of a macro formula, so please, can anyone here help me with this?

sorry if I was not clear enough. There are some employees in the department who are not suppose to have access on the data of every company, therefore it will be harmful if we put it like an open excel file with filters.