the dat i need to pull into the summary sheet is itself a summary of the data
on each worksheet. the worksheet itself is used for various other purposes.

"Don Guillett" wrote:

Why not just have the master sheet with a column for sales person name and
then filter when desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"a m spock" wrote in message
...
I have a workbook with an ever increasing number of worksheets - one for
each sales person with a standard layout. The data on each sheet gets
summarised in specified ranges of that sheet like a1:a5 for sales of
different and g9:g13 for value of sales etc. I need a summary sheet where
for each sales person there is one row showing his name (same as worksheet
name) and only these cells.