Hi there,

I am looking for help with a spreadsheet formula,

I have 54 Worksheets and on Line C6 of each worksheet is the Description and
on
E6 of each worksheet is a Name. I would like set up another worksheet that
will list the information on E6 from all the other worksheets to one
locations.

Sheet 1
C6 D6 E6
Manager Bill Taylor
Assistant Manager Brenda Davidson

Sheet 2
C6 D6 E6
Manager Eric Bradley
Assistant Manager Monica Davis

There is a lot of other information on each worksheet, but what I am looking
for is to have the names of all the Managers from the 54 worksheets on one
worksheet, and also the names of all the Assistant Manager from the 54
worksheets on one worksheet. Is this possible. Thank you

Newfie