Don't use separate sheets. BAD idea in general. Instead, you could

1) simply apply data filters, then choose the sales person of interest from
the dropo down. Use SUBTOTAL functions to perform calculations with the
data that remains.

OR

2) use a pivot table, with sales person as the row field, and other fields
as data or column fields.

HTH,
Bernie
MS Excel MVP



"trinab" wrote in message
...
I have a large spreadsheet with about 25 columns, I want to pull
information
from this sheet to individual sheets within the same workbook. IE I have
a
sheet labelled sales and I want to pull all the sales to a separate sheet
for
sales persson a & b but not c. Lets say all the sales (a,b,c) are in
column
b.

Trinab