Issues with VLOOKUP/INDIRECT and retrieving from multiple sheets

Hi all,

I'm having issues with data populating from multiple sheets based on information from a drop-down. I have a drop-down list of names (Report -- C20) that will populate information based on that person's sheet. I also set up a sheet for each employee.

I'm having issues with the information populating correctly below. I tried using indirect but the formula wouldn't fill down correctly or just gave wrong information for blanks. I manually typed in a formula from C23 - F26.

I just want to be able to select a name and have all of that information displayed in the table below.

Is there a better way to do this? Thanks for your help!

That worked, kind of. When I fill the formula down and there is no information, it shows the date as "1/0/00" and everything else as "0"

I attached the amended workbook with your formula, as well as a similar report example (Report 1) that I created with the help of the great folks from this forum. On the example, there are no blank values showing up when the formula is copied down. I was hoping to create something similar in this new report.

Thank you again!

This is perfect, thank you so much!