Reference across sheets

[noomi]

I am trying to reference the tab name in Column A(Employee A, EmployeeB, Employee C, ....) of sheet F0301QA00810 to sum the total of each employee that has F0301QA00810 in column K by using sumproduct.

[Bob Phillips]

Are you trying to sum across many sheets? What value/column are you trying to sum?