To filter data based on a particular value in other sheet

Hi All,

Please help me with getting particular set of data from a sheet into different sheets in the same document.

1. There are 3 columns in the first sheet (master sheet) in the excel document - Project,Created by,Effort spent
2. In the 2nd sheet of the same document, I need to filter based on one project (Foe eg: Hello Time) and get the "Created by" and "Effort spent" data
3. I need to separate the data similarly for all projects in different sheets of the same document

I have attached the screenshots for your reference. Hoping to have your help on this. Thanks in advance.

Thanks a lot for the reply. I will be updating/changing the content of master sheet every week. The data in other tabs should get updated automatically. That is the sole purpose of me doing this.

Thank you. Will check these.