I am creating a performance tracker for my employees, and I'd like to have a sheet named for each person's first name, with all the metrics by date. I'd then like to create a performance page that will let me use data validation to have a drop down of employee/sheet name and date to pull in just the information for that person.
In my mind, it would look something like
=FILTER(SHEETNAME(A1)!B2:D3,SHEETNAME(A1)!B2:D2 = C1)
where A1 would be the dropdown list of names of the sheets.
I'm very self taught, and my knowledge of Sheets has a LOT of gaps, so any advice would be incredibly helpful!