I am building a workbook that has one "master" worksheet. This shows total
hours for various employees, and the first column will be their employee
number.
I will then have individual worksheets for each employee. The worksheet
name will be their employee number, and each person goes into his/her own
sheet to update their hours worked by each day, which will then be totaled
for the entire month.

I want the main worksheet to lookup the total hours for each employee, based
on what is on their individual worksheet. Can I set up VLOOKUP (or another
function) to accomplish this? The sheet name used in the VLOOKUP formula
would have to be each persons' employee number.

Thank you