Get instant live Excel excel help and learn how to use VLOOKUP across multiple sheets

trying to link datasets from multiple sheets and use vlookup

hello I want to make a time sheet in excel for the company employees its attached I don't want to create a separate file for each employee then multiple sheets in each file for each month I saw some files online where you create a drop down list for employees then whenever you choose an employee you get his own data in the same sheet is this related to conditional vlookup and can only be applied when the changes between employees data are only in formatting? is it related to VLOOKUP? I also want to apply the same concept to years/months so I can stay in the same sheet while viewing the details for all employees for whatever year or month I want thanks

I'm writing a vlookup that is supposed to check for a single value across multiple worksheets and return the information I specified. I already got it to work for references to multiple sheets within the workbook by specifying those sheets in the named range, SheetList. However, what I need it to do is look at multiple separate workbooks instead of multiple separate sheets within the same workbook. I know I can get it to work if I just put the workbook names in the named range that the formula uses, but I can't figure out what conventions or syntax to use to name those workbooks.

i'm doing a vlookup across multiple sheets but i don't have a specific value to search on