I have created a project and hours tracking spreadsheet in Excel. There is a Overview page that collects data from each of the project sheets (I have attached a screenshot for reference). As I enter the hours on the project sheets they combine together on the overview for that person for that day.


I am looking for a way to choose a cell on the overview sheet and find all of the sheets that has time on them that are for that person on that day(where that time came from). I only want to return that have a value in them. The same person may work on multiple projects in a single day and there time is broken up over those projects.

Any help would be greatly appreciated. I will try to answer any questions as quickly and detailed as possible. Thank you in advance.

Attached Images

Time Sheet.jpg (178.7 KB, 35 views)