VLOOKUP formula across multiple sheets

Marymog 

I realize that the actual spreadsheet almost certainly contains the real names of real people, as well as perhaps other confidential information. If there is any possibility of your creating a facsimile of it that uses, say, the names of Star Wars or Disney characters in place of the actual names, it would really be helpful to see how you've organized the data. In particular, I wonder why you seem to think it necessary to have multiple sheets with redundant (or so it would seem) data.

My very frank reaction on reading your description is to think you probably would benefit from re-thinking the basic design here.  Excel really is good at taking single databases (in the form of a well-designed Excel Table), for such things as employee attendance records, and then producing the kind of report you're trying to create. I say this as a person who was the director of the HR/Payroll database for a major corporation (I'm now long retired).... I've worked with this kind of data for decades...what you describe sounds as if you've taken what used to be a method of keeping records on paper and moved it to Excel, hoping to take advantage of Excel's magic to do some of the review and summarization of attendance logs, but maybe you didn't really re-think the method of keeping the raw data in the first place.

If you're open to that kind of re-thinking, in the long run you'd benefit. Creating a formula that can navigate a poor design [if my impression is in any way correct] may be possible, but it's the equivalent of just putting a larger bandage on an infection, rather than treating the underlying cause.