Forum Discussion
how to show what projects each person is working on
There is a variety of ways to do this (always true with Excel).
I have a workbook consisting of multiple sheets used to track various investment positions I have. And there's a single sheet that summarizes key data from each of the individual sheets. To a certain extent this parallels what you're describing.
One crucial aspect of mine--and I can't tell if this is true for yours--is that I've made an effort to be consistent with the placement of those "key data" elements on each individual sheet. I then make use of the INDIRECT function to point to those key data elements on each individual sheet, constructing an address that consists of the sheet name and the cell reference (row and column).
INDIRECT is a tricky function to master (not sure I have, even though I use it), but is powerful. Here's a webpage that explains it well. https://exceljet.net/excel-functions/excel-indirect-function
If you need more help, would it be possible for you to post an example of one or two of your individual project sheets (after rendering anonymous any names or other confidential info) as well as a simplified version of what you want for the dashboard? I ask because it might be easier for me or somebody else here to demonstrate the method with your actual layout, rather than to construct our own example...