I'm going to use a hypothetical for this because I don't know how to explain it lol

I'm a receptionist and I keep a database of clients, each with a number. Some visit my business regularly, others not so regularly. Every time they visit I enter their number and what they purchased when they visited. I have around ten fields of items, and 300 visit entries. The clients bought differeny things every time.

Is there a way for me to type a client number into Sheet 2 and have all the visits and purchases from that client pop up?

Thanks for any help