Filtering Based on Fixed Value

[Jennsy]

Hi,

I am trying to create an overview worksheet in a spreadsheet that can dynamically list the a filtered list of results from another worksheet based on a fixed value.

If you look at the attached spreadsheet you will see that I have two worksheets:

1. Client Overview
2. Clients

What I am trying to do is make the "Client Overview" sheet populate with information automatically from "Clients". In the example attached the overview is for Coke, so I want to show all the Coke projects from "Clients" dynamically with their corresponding information. At the moment I have hard written the project information in "Client Overview", but I want to add multiple tabs for each client, and want this information to be pulled in automatically using a formula.

Is this possible?

Many thanks,
Jennsy