Excel, formulae counting

Hi - as an interim workaround, pending  test tool procurement, I'm looking to capture multiple values/outcomes Pas=ss, Fail of work items run by different people on different rows and sheets and link  it to display the summary of totals on a master summary sheet. Please help? Thanks