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.