Summarizing Worksheets

[Guest]

I have multiple worksheets. Each worksheet has a list of employees and one of three possible shifts. I would like to create a summary worksheet that has three columns, one for each shift, and the names of all employees that work that shift.

 

[Frank Kabel]

Hi
could you provide some more detail about your data sheets (some example
rows as plain text?)

 

[Guest]

Each worksheet has three columns as follows
ShiftType EmpName ShiftTim
A joe 8:00-3:0
B mary 11:00-8:0
A fred 8:00-3:0

I would like to create a summary worksheet that looks like
Shift A Shift
joe mar
fre

and any other employees from all other worksheets.