I have an excel spreadsheet, which I call the 'master' with approximately 200 worksheets. Each worksheet is linked to it's own excel file, so that when each file is updated, these updates are shown in the 'master.' Together, these make up a list of projects. In cell C2 is the status (such as Complete, In Progress...), D2 is the tracking number for the project (1.1, 1.1.1, 2.1, 2.1.1...) and in cell E2 is the name of the project (just text). I need a way to group these three sets of data together, grouped by status. Therefore, I am looking for a list of all of the completes, with the name and number, all of the in progresses with the name and number, etc. Also, this list needs to be updated each time the file is opened.

I think that the solution would be similar to a filter, but the problem is that the data is spread out over 200 worksheets.

Thanks for any help or responses.