just a count of how many times the name bob brown appears in the U

column on each page

JoshBrunz

Well, one way, on each sheet in a discreet cell enter this formula, (I used F1 on each sheet). Adjust formula to that sheet's name.

=COUNTIF(Sheet2!U:U,Sheet1!A2)

Bob Brown is in cell A2 of sheet1. And A2 could be a drop down with other names.

Then on sheet1 this formula =SUM(Sheet2:Sheet6!F1)

Where sheet2 is the first sheet and sheet6 is the last sheet.

Regards,
Howard