I’m creating an excel doc to map out and organize features for a project. I have the different features broken down into separate worksheets. N each worksheet there are three columns. A is the story number, B is the description and C is the sprint number. I would like to create a master sheet that will group the data from the various worksheets based on the shared value in column c. For example, everything that has a value of 9 in column c across all of the worksheets would be grouped together. I’d also like each of them to link to their location, so if story 100 is scheduled for sprint 9 and is in the search UI feature worksheet, and story 101 is scheduled for sprint 9 and us in the email feature worksheet, they would be grouped together on the master and I would be able to see all three column entries for each. If I were to click on the search UI feature row, I would be taken to the Search feature worksheet. I would also like the master worksheet to update whenever any of the data on the other worksheets are updated. Is this possible in excel? This is a work document and I cannot attach anything. I am using a PC, windows 10 I believe.