Help locating specific data from range

Hello all,

I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc.

Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name.

I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful.

Thank you