Pulling Data from Multiple Sheets as Summary

Thank you, I think I fixed the title.

No, it's different. Though, the concept is somewhat similar, I'm needing something beyong VLOOKUP as it's intertwining other functions as well.

In your posted w/book, there are about 80 names on Tab1 but about 30 on Sheet1 so are we to assume the balance of the names will be on Sheet2, Sheet3 etc so a VLOOKUP (or similar) over multiple sheets is required. If so, your posted file should reflect this.

I think it's needing more than that such as CountA or CountIF functions

What do you mean by the above ???

My apologies, I didn't know.

You're right, my apologies. I'm very new to this.

I've attached an update workbook.

And with the CountA or CountIF function, I don't know if I need to intertwine the VLOOKUP function with either of those. For example in the first/front sheet I need it to tally everything I have in the other tabs. So, for example if "Jonah Hill" had 1 meeting in Sheet1 and Sheet2, then the tally would be 2. Taking a closer look at what CountA does, I can see that that's clearly not the right function for what I need this for.

Created a named range "Sheets" in M2:M4

This counts the number of 60 minute meetings attended

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&Sheets&"'!$B$2:$B$100"),C4,INDIRECT("'"&Sheets&"'!$F$2:$F$100"),"=60*"))

Not sure how this fits with different forms of attendance (column D) ("in person" , "over the Phone"

This is a great start. Is there a way to convert the response to Y, N, or Y/N?

How do you convert 3 attendances into Y, N, or Y/N ? Equally, how do you record 2 "In person" and 1 "On phone" in your table?

If the meeting was under 60 minutes, I'll document it as an N. If the meeting was 60 minutes, I'll document it as a Y. If one client one week had a meeting for 45 minutes, but the next week for 60 minutes I document it as Y/N.

The In Person and Over the Phone is a bit trickier. The Sheet1 is my baseline that I go with; if they had an In Person meeting, I'll write it as such. If they had an On Phone meeting the following week, I would document it in the column titled, "CNS if Diff from Other Sess". Same goes if they meeting with another agent that's different from the first week.

This brings in much more complexity as it requires the evaluation, and comparison, of several sheets (can there be more than 3?)

It's typically 4-5 sheets.

I think this is exactly what I need, it's really genius. I'm going to have to play around with it to see how I can implement this in my workbook, but this is exactly the result I was looking for. Thank you!