Yikes! Look ups? Match?
 

I have forty workbooks for individual surgeon , each contain the same data.
Each workbook has FYO6 total volumes, and each month of this FY. I need July
and Aug totals from cell rangs AG4:AG31.

I have a clickable sheet with all the workbooks listed in alpha order. And
I think I can run something to get the months list on the sheets and the
surgeons names in a cell as well...so I know what data belongs to who...

Question is, how can I get the totals for the months of July and Aug with
the names of the surgeons and month asssigned to each cell approbriately?

Or is this all wishful thinking....a pipe dream...?

Thanks so much for taking the time to read and for the help or
intervention... :)
--
Jules