I've got a master worksheet containing data - with ten identical analysis
worksheets (at the moment, each with the name of a different Sales Rep.

I want each analysis worksheet to analyse the data purely for that Rep and
I'm trying to get to a solution where all my analysis formulae point to the
worksheet name to pick up the name of the Sales Rep - which then makes it
easy to add or change people.

Currently there is a column in the master worksheet which is a named range
called 'sales_rep' and my formulae are typically of the form.

=sumif(salesrep='JKS',salesvalue)

What I'd like to get to is

=sumif(salesrep=worksheetname,salesvalue)

Is there a way I can achieve this.

TIA

Rob