Creating Sub/Individual Sheets from Master Sheet

Hello,

I am trying to create a document for my team and myself where we can enter in tasks into a 'master' sheet with columns such as, "project ID, date created, issue, ball in court, resolution, etc", then subsequent sheets would be populated/available for each individual project ID to be able to drill down to just those. Thus, giving us a whole view (master sheet) and fine view (per project) of outstanding tasks. I've messed around with some stuff from google utilizing pivot tables to create sheets for each project but I find that it doesn't populate the other necessary information. I'm also having trouble getting it to auto populate, so if a new task is entered it will be shown in the appropriate project tab. Is this possible within excel? Is there a better/easier way to go about it?

TIA