I have to generate a report that references data from 3 Worksheets, all 3
worksheets are identical and the coloumns will not change, however new rows
and data is added regulary.

I need to Sum all the numerical values in column F from each of the three
worksheets that reference to specific Text fields (i.e "Student", "Teacher")
in column B.

The worsheets have numerous blank cells but the text is is consistent as it
is generated from a drop down menu.

Any help is greatly appreciated...